Using IF and isblank function to print column value

Hello, I am new to smartsheets and am having a little difficulty getting my spreadsheet to print the actual column value when using if and is blank.

I have two columns: a request by date (manual) and due date (automatic).

The formula should first read the request by date column and print that date if there is a value however if the column is blank, then it should print the usual due date.

=IF(ISBLANK([Request Date]@row), ([Due Date]@row,) ([Request Date]@row))

This only gives me an #UNPARSEABLE response.

I was planning to combine this with a simple formula to track days until due via =(above string) - today().

Let me know if I am missing something, thank you!

Find more posts tagged with

Accepted answers

Kelly Moore

oh. I didn't realize you had a 3rd date. By the way, this is in a 4th date column, correct?

We received an invalid data error from [Request Date]=0. A date column wouldn't have a zero. I misunderstood you when you mentioned a third column needs to be checked-I thought you meant a checkbox column. My bad.

=IF([Column1]@row<>"", [Date1]@row, IF([Column1]@row="", [Date2]@row, IF(AND([Column1]@row="", [Column2]@row=""), [Date3]@row)))

plug your columns into the above.

All comments

John Fasano

I forgot to include a 3rd column that needs to be checked, so two columns would need to be blank for the date to revert to the original due date, thank you!

Kelly Moore

Hey @John Fasano

Try this

=IF(AND(ISBLANK([Request Date]@row), [your checkbox column]@row=0), [Due Date]@row, [Request Date]@row)

be sure to replace insert your real checkbox column name into the formula.

In your original formula the terms were enclosed in parentheses - this prevented the formula from executing.

Let me know if I need to tweak this further

cheers

Charlene Dewbre

John Fasano

Hi KDM, thanks for responding.

I tried that and am getting an #INVALID error. Here is what I put in.

=IF(AND(ISBLANK([Request Date]@row), [Request Date]@row = 0), [Rev Date]@row, [Due Date]@row)

Recap of flow: If Column 1 is not blank, then show Column 1 Date. If Column 1 is blank, then show Column 2 Date. If Columns 1 and 2 are blank, then show Column 3 date.

Let me know what you think I might've messed up, thanks!

Kelly Moore

oh. I didn't realize you had a 3rd date. By the way, this is in a 4th date column, correct?

=IF([Column1]@row<>"", [Date1]@row, IF([Column1]@row="", [Date2]@row, IF(AND([Column1]@row="", [Column2]@row=""), [Date3]@row)))

plug your columns into the above.

John Fasano

Would this be a correct interpretation? All of the cells lead to the correct columns however for some reason it is giving me a #INVALID COLUMN VALUE.

All of the columns are formatted as dates.

=IF([Request Date]@row <> "", [Request Date]@row, IF([Request Date]@row = "", [Rev Date]@row, IF(AND([Request Date]@row = "", [Rev Date]@row = ""), [Due Date]@row)))

Thanks for working with me.

Kelly Moore

Ok, I cleaned it and tested it on my sheet. It works. Hopefully I kept your conditions straight. Let's see what you get.

Kelly

John Fasano

Ok that worked, I wasnt testing it with the full formula since I was pulling from Date formatted columns and ending in a text/number column where the date would only be converted when I added in the rest of the formula.

Thank you very much!

Kelly Moore

Hey

Glad you got it working. I just saw the last 'cleaned up' formula didn't post. oh well.

Glad you are part of the community,

cheers

Kelly

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.