Trending in Formulas and Functions
-
At Risk Flag
Hello All, I'm trying to enable an at risk flag with the following criteria: Within 3 days of date to follow up if the status is either "open" or "deferred" ignoring any rows that have blanks for dates I've been searching the forum, I found one that worked, but flagged every empty row at risk because there were zero…
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
If, Then with a date and N/A
Hello, I'm attempting to put 3-4 arguments together. I can get 3 to work, but not the 4th. I have 3 columns: Letter Due, Letter Sent, and Sent in Window. The Yes, No, N/A are calculated for Sent in Window using the below formula =IF(AND(ISDATE([*Confirmation Letter Due*]@row), ISDATE([*Confirmation Letter Sent*]@row),…