Formula errors

NTG
✭✭
- Schedule Variance:
- Getting errors Invalid & Unparseable.
- My best guess to those results. Are the other columns that it's looking at have cells that are blank. ( actual finish date) resulting from the fact that that task is not completed yet. Thus nothing to draw from
- What I’m trying to have the formula pick up...is that if the cell is blank…””…that it will produce the Unchanged symbol.
- The formula works fine. But once I insert the last piece (in bold below) of the 2nd formula it produces the error messages above
- What I’m trying to have the formula pick up...is that if the cell is blank…””…that it will produce the Unchanged symbol.
- My best guess to those results. Are the other columns that it's looking at have cells that are blank. ( actual finish date) resulting from the fact that that task is not completed yet. Thus nothing to draw from
- Getting errors Invalid & Unparseable.
Formula that works: =IF([Planned Finish]4 - DATEONLY([Actual Finish]4) > 0, "Up", IF([Planned Finish]4 - DATEONLY([Actual Finish]4) < 0, "Down", "Unchanged"))
Formula that doesn’t work: =IF([Planned Finish]1 - DATEONLY([Actual Finish]1) > 0, "Up", IF([Planned Finish]1 - DATEONLY([Actual Finish]1) < 0, "Down", "Unchanged", IF([Actual Finish]1 = "", "Unchanged"))))
Tags:
Comments
-
Try: =IF([Planned Finish]1 - DATEONLY([Actual Finish]1) > 0, "Up", IF([Planned Finish]1 - DATEONLY([Actual Finish]1) < 0, "Down", "Unchanged", IF(ISblank([Actual Finish]1), "Unchanged"))))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.1K Get Help
- 449 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 514 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 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!