#UNPARS ERROR
Hello, I am attempting to create a formula that will post a RYG symbol after comparing two date columns. The formula:
=IF(([PO Receipt Date]@row >=TODAY(+14)), "Green”, IF([PO Receipt Date]@row <=TODAY(+13)), "Yellow", IF([PO Receipt Date]@row < TODAY()), “Red”)
But continue to receive #UNPARS error. Im new to SMARTSHEET so any help is appreciated.
Best Answer
-
Hi @Tom P !
Try:
=IF([PO Receipt Date]@row >=TODAY(14), "Green”, IF([PO Receipt Date]@row <=TODAY(13), "Yellow", IF([PO Receipt Date]@row < TODAY(), “Red”)))
Moved around some parentheses that were likely causing problems!
Ashley Knight
Answers
-
Hi @Tom P !
Try:
=IF([PO Receipt Date]@row >=TODAY(14), "Green”, IF([PO Receipt Date]@row <=TODAY(13), "Yellow", IF([PO Receipt Date]@row < TODAY(), “Red”)))
Moved around some parentheses that were likely causing problems!
Ashley Knight
-
Thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!