IF Statement subtracting Dates

Brandon03

Brandon03 ✭

09/24/21 edited 09/24/21 in Formulas and Functions

0 ·

Best Answer

Brandon03 ✭

09/27/21 Answer ✓

Got it

0 · Share on Facebook Share on Twitter

Answers

Jason Duryea ✭✭✭✭✭✭

09/24/21

Hopefully I read the field names in your screenshot correctly.
=IF([OK/NG CM]@row <> "CLOSED", Today - [CM DUE DATE]@row, 0)

0 · Share on Facebook Share on Twitter
Brandon03 ✭

09/27/21

Returning unparseable...also I need if closed is anywhere in that cell

0 · Share on Facebook Share on Twitter
Brandon03 ✭

09/27/21 Answer ✓

Got it

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Using Nested If and Formula to Set Value of Field
I'm trying to set the value of a field using an IF statement based upon a calculated number in a column called "Tier Score". =IF ([Tier Score]@row <= 17, "Tier 3", IF ([Tier Score]@row <= 25, "Tier 2", IF ([Tier Score]@row >= 26, "Tier 1"))) I keep getting UNPARSABLE. Thanks
Add to INDEX formula to account for blank cells?
I have a mapped column that displays a Contact based on what's inputted in another cell. E.g. Slim J = Slim Julian. Here's the formula: =INDEX({PD - NetSuite Name Mapping USE Range 1}, MATCH([PDS Selected]@row, {Formstack Name}, 0)) However, if the cell is blank, it just assigns the first Contact alphabetically, even…
Fiscal Year "lookup" formula request
Hi :) I'm trying to get this lookup to pull in the FY for us but these always give me a hard time. I have the excel formula but I don't really even understand it so not sure how to translate it to Smartsheet talk. Excel: =LOOKUP(2,1/((H268>='Lookup Data'!$B$2:$B$21)*(H268<='Lookup Data'!$C$2:$C$21)),'Lookup…