Can't get remove invalid operation on this
Hi Smartsheet's team,
Appreciate to help me out as i have these formulas that i am trying to add another function of showing blank if no data has been uploaded.
for PR duration
For PC target submission
As you could see it works if the cell has a date but when it is still empty i can see this #invalid operaiton. Is there a another arguement i can add to have it seen as blanks if empty?
Answers
-
I tried to copy your set up and mine shows OK, and I receive no error. Just some notes to check:
- Make sure all column dates are set to date format.
- Delete those blank rows.
- Make the column with formula as column formula
PR Duration Date = IF(ISBLANK([PC Sent Date]@row), (TODAY() - (IF(ISBLANK([PR Ext Due Date]@row), [PR Due Date]@row, [PR Due Date]@row))), IF(ISBLANK([PR Ext Due Date]@row), ([PC Sent Date]@row - [PR Due Date]@row), ([PC Sent Date]@row - [PR Due Date]@row)))
PC Target Submission = IF(ISBLANK([PR Duration Date]@row), "", IF([PR Duration Date]@row < 1, "On Time", "Delayed"))
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!