Welcome!

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-

Find more posts tagged with

Comments

Mike Wilday

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")))

Mike Wilday

Whoops. I had to edit that... there was a minor error in in the last actual finish date. That should work great for you.

djpreece

'Thanks Mike, its working, changed case of text and matched your spacing in the formula....but hard to believe that was the cause!

-dp-

Mike Wilday

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Is it possible to edit an email list in an automated monthly report?
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
User Friendly Search
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
2 part automation delay question?
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…