Slight error in formula
Hi All,
You may be able to shine some light on my formula issue. I have implemented the formula below which flags when 'Due date on site' is in the past and 'Item Closed is not checked, but does not flag if the date fields are blank.
The problem arises when I tick the items closed, it produces a #Invalid data type where it should just unflag.
The formula is working for me in so much as I am using the flag as a report trigger, but I would like to have it clean.
=IF(ISBLANK([Date Due On SIte]@row), 0, IF(AND([Date Due On SIte]@row < TODAY(), IF([Item Closed]@row = 0, 1)), 1))
Thanks in advance,
John
Best Answer
-
=IF(ISBLANK([Date Due On SIte]@row), 0, IF(AND([Date Due On SIte]@row < TODAY(), [Item Closed]@row = 0), 1))
Try that.
Answers
-
=IF(ISBLANK([Date Due On SIte]@row), 0, IF(AND([Date Due On SIte]@row < TODAY(), [Item Closed]@row = 0), 1))
Try that.
-
Hi Paul,
Yes that worked a treat.
Thank you for the quick response.
John
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.2K Get Help
- 386 Global Discussions
- 212 Industry Talk
- 445 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!