Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Nested IF statement - with checkboxes
I am looking for an IF statement to check the box if true, but do not check the box if NOT true.
=IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), " "))
I have an Actual response date, so when the date is over the due date OR is blank, I do not want the checkbox to have a checkmark. This statement works but checks if the actual date is BLANK. I cannot get it to NOT check it. HELP
Comments
-
Is it possible that you are having the problem when Response Due Date is also blank?
If so then the Actual and the Response are = so the box gets checked
-
Try changing your " " to a 0. For the checkbox symbol, 1 is checked and 0 is unchecked.
=IF([Actual Response Date]47 <= [Response Due Date]47, 1, IF((ISBLANK[Actual Response Date]47), 0))
That should do the trick for you if the Actual Response Date is blank.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives