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
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 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!