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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!