-
Average
I would be grateful if someone could tell me what to do. I want to find the average of columns A and B on a sheet. If column A has data and column B does not, what formula should I use?
-
IF(ISBLANK formula for multiple columns
Hi I want a formula to show which team has been selected across multiple columns: So if Construction has been chosen, in one of the columns, this will show in the Team column. Only one team will ever be selected per row. The formula I have is shown above but it's returning a #impasserable I'm assuming I've got too many…
-
How to convert Excel formula to smartsheet formula
=IF(H2>25%,IF(I2>100,"High BIPOC", "None"),"None") =IFS(H149>10%,IF(H149<25%,IF(I149>100,"Medium BIPOC Provider","None"),)) And lastly a formula that will show low Bipoc
-
INDEX MATCH works then returns #NOMATCH upon saving the sheet.
OK, I'm really stuck on this one... I've written a simple index match formula... =INDEX({TSRCC}, MATCH([Unique Event+Session Date]@row, {TSR Event Name}, 0)) It worked perfectly fine. Then when I saved the sheet all rows changed to a #NOMATCH error. When I rewrite the formula, it worked again, then when I went to save, it…
-
Help with returning Yes value if multiple criteria is met
I am trying to identify which RED customers from one Sheet 1 have already been added to our CEM (Customer Escalation Master) Sheet 2, so I don't have to manually spot check between both. I created a new Column called, "On Escalation Master?" and want to return a Yes or No value. I am getting #UNPARSEABLE error when I try…
-
Best method to return a list based on a multi-select column
I hope I'm close with this solution, but I just can't make the formula work. I have a list of therapists who are licensed in multiple states. Sheet with formula: A list of patients needing a therapist. Their state is indicated in a "State" field. Second sheet: A two-column range of "Therapist last name", and "States…
-
How do I add AND to a COUNTIF (COUNTIFS) formula?
Hi, I am tearing my hair out trying to create a formula (for a Sheet summary) that will count the number of rows that has the term HECF in either the Area of focus or Other column. So in the example below, the formula would return "4". I'd appreciate any help with this. Thanks!! Is there a way to combine or add COUNTIF…
-
Smartsheet definitely needs to increase their cross sheet references
Smartsheet has tons of potential for a perfect operational system, with tons of automation with formulas, but the only problems here are maximum of 20,000 rows (it's even lagging before it reached 10,000). Maximum Cross Sheet References of 100,000 rows combined, which became a ceiling for a system to improve. I know the…
-
Conditional formatting
Hi All, i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column
-
What is the syntax to use automation to change cell value to another cell's value (same sheet)?
I tried {{MyColumnNameHere}} but it displays it like a text string. Please tell me this is possible and I just have the wrong syntax...
