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

Formula Help: Multiple if conditions
I am struggling with the right formula for the following situation. I have a "Renewal" column that is a date. Not all rows will be relevant, therefore some rows will be blank. I have a "Asset Condition" column that is set to be one of three symbols, Yes, No, Hold. I would like the Asset Condition column to return Yes if…
Is There A Way To Set A Character Limit?
I am hoping to set a character limit within a SmartSheet form when people use the form for submitting something. Is this possible?
copy paste and predecessors rows
Hi i built sheets with predecessors and duration columns to create logistics between rows. it always works well until some people start to work with the sheets and i don't understand the issue. when I do a copy paste of a row, it copy the same date in the coumn "date" BUT, when some other people do the same copy/paste, the…