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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 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!