#Invalid Operation
Comments
-
This is a weird one. Are your column names accurate? Very weird indeed. I would report this one to smartsheet support.
https://app.smartsheet.com/b/response?type=11&_ga=2.160561018.65390117.1559058841-61535698.1548289777 -
So my formula is correct? All the column names are correct. It's driving me nuts!
-
Are you trying to get it to display text or leave blank since there is no data in the row?
If you are wanting to leave it blank since there is no data, you could build an additional IF statement on the front end saying to run if (for example) [Date Range End]@row is a date.
=IF(ISDATE([Date Range End]@row), IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE"), "")
-
Hi Paul,
This worked perfectly, thank you so much. Now I understand what I wasn't doing correctly.
Thank you!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!