Trying to combine if and statements in formula and keep getting incorrect syntax
Trying to return three different results for the above statements.
This is the formula I have been using:
=IF(AND(Status@row = "Open", [Targeted Completion Date]@row < TODAY(), "Red", =IF(AND(Status@row = "Open", [Targeted Completion Date]@row <= TODAY(+3)), "Yellow", "Green")))
What am I doing wrong?
Answers
-
=IF(AND(Status@row, "Open", [Target Completion Date]@row, <TODAY()), "Red", IF(AND(Status@row, "Open", [Target Completion Date]@row, <=TODAY(3)), "Yellow", "Green"
What you were doing wrong was not separating your range with criteria in your AND statements. You also do not start a nested IF with another equals sign.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!