Incorrect Argument
Hello,
I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument.
I had it working correctly when I was just doing red and green, but I really need that go between to show it is not yet out of compliance.
=IF(NOT(ISBLANK([Date Completed]@row)), "Green", IF([Due Date]@row) > TODAY(), "Yellow", "Red")
Any advice would be helpful. Thank you!
Best Answer
-
Hi @CHefner try this:
=IF([Date Completed]@row <> "", "Green", IF([Due Date]@row > TODAY(), "Yellow", "Red"))
In smartsheet the NOT EQUAL TO operator is <>, so the fastest way to check for NOT ISBLANK is to check using the <> with ""
The rest of the formula you had is almost correct, but the parentheses are in the incorrect places.
Sincerely,
Jacob Stey
Answers
-
Hi @CHefner try this:
=IF([Date Completed]@row <> "", "Green", IF([Due Date]@row > TODAY(), "Yellow", "Red"))
In smartsheet the NOT EQUAL TO operator is <>, so the fastest way to check for NOT ISBLANK is to check using the <> with ""
The rest of the formula you had is almost correct, but the parentheses are in the incorrect places.
Sincerely,
Jacob Stey
-
That worked perfectly! Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives