Formulas
Discussion List
- Seeking help on a formula to show RYG. I was getting an unparseable error, however most recently receiving errors regarding syntax. I want show the following: If % complete is 100%, Green If today is …
- I have a sheet that has some weekly inputs. I've created a simplified Report View to only pull in the applicable columns from the most recent weeks/rows of data for the SME to populate. Recently, we h…
- Hello Smartsheet World! I am attempting to run a formula that will return contact emails depending on which departments are selected in a multi-select dropdown column. Sheet 1: Improvement Notes Smart…
- I created a tracking spreadsheet for our annual law school on campus events and on this spreadsheet, we list within the same column all of the attorney participants we send on campus for that law scho…
- I have been able to figure out how to count distinct values in a column. Now I would like an additional complexity of asking the formula only to count cells if it meets the criteria in another column.…
- Hello, I am trying to create a formula that will pull in a distinct text with multiple criteria. I do have a helper column. The original formula I used works in a different scenario where only one cri…
- Hoping someone can help: If conditions meet the below criteria, then Program Health result be be "Red" if not result would be "Green" 1st Requirement: Column "Essentiality" = "No-Go" 2nd Requirement: …
- Hi, I am trying to create a count if function that will count all the cells that include text in a row, but not if that text is "NONE" or "CURRENT REQ" I've gotten this far, =COUNTIFS(Taleo11:[Media 5…
- Hello, I have sheet where I am trying sum the total number of hits in the month of January if the text in one column matches text in a rand of cells on another sheet. I am using =SUMIF(Title:Title, CO…
- Hello, I am trying to sum rows in a column if a text in 1 column matches text in a range in another column. And have that number show up in a Summary field. If we look at the sheet, I want to sum valu…
