Out of Practice, Need 2 Variable Flag (At Risk) Help
I haven't been a good girl practicing my formulas. Everything I've tried is coming up Uparseable.
What I'd like to do: Red Flag when "Expected Completion Date" is within 5, days, or in the past, and "Current Status" does NOT equal "Complete".
I'm feeling pretty silly that I've spent so much time trying to get this to work. I'd love any help offered on a working formula
Tags:
Answers
-
Try something like this:
=IF(AND([Current Status]@row <> "Complete", [Expected Completion Date]@row <= TODAY(5)), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 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!