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.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
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives