Why is this #UNPARSEABLE??
Hi all,
don't understand why this is ##UNPARSEABLE..
=IF(ISBLANK([Actual Finish Date]39), "", IF(ISBLANK([Actual Start Date]39), “ERROR1”, IF([Actual Start Date]39 > [Actual Finish Date]39, "ERROR2" , “” )))
Really appreciate if someone can tell me why...
Thanks
-dp-
Comments
-
I was able to get the following formula to work on a row 23. in my test sheet. If you adjust the row number it should work just fine for you. Not sure what the issue was... The IF argument assumes that if none of the following are true, then it will be blank.
=IF(ISBLANK([Actual Finish Date]23), "", IF(ISBLANK([Actual Start Date]23), "Error 1", IF([Actual Start Date]23 > [Actual Finish Date]23, "Error 2")))
-
Whoops. I had to edit that... there was a minor error in in the last actual finish date. That should work great for you.
-
'Thanks Mike, its working, changed case of text and matched your spacing in the formula....but hard to believe that was the cause!
-dp-
-
I've had issues where improperly formatted quotation marks can cause that behavior cause Smartsheets doesn't recognize the character as a Quote. Sometimes quotes in Word processing programs substitute smart quotes or characters that actually change the character and therefore don't read right. I use Notepad++, or a similar text editor to ensure my characters are correct. They use plain text instead of HTML and will reveal issues like that.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives