Unparseable Error in IF(And formula

I'm trying to create an IF statement that relies on the data in 2 cells. Basically, if one cell is checked off and the other is empty, I want to create a formula on a new cell (which I will hide) so I can ultimately send an update request to the user to fill in the notes field. I haven't used the AND formula nor have I (successfully) used the ISBlank function. My attempt at the formula is below...

=IF(AND(Complete?1 = 1, Notes1 = ISBLANK, 1, 0))

=IF(AND(Complete?1 = 1, Notes1 = ISBLANK), "True", "False"))

Keep getting unparseable errors. Does anyone know what I'm doing wrong?

Find more posts tagged with

Formulas

Comments

JoeC.

Hi Deb,

ISBLANK is also a function (like AND), so if you use the following syntax, it should work:

=IF(AND(Complete1 = 1, ISBLANK(Notes1) = 1), "True", "False")

Deb Gordinier

HI Joe - I did try your formula but I couldn't get it to work. I also tried removing the =1 after isblank and the cell because I thought it might be redundant since the essence of that function is to be empty, needless to say, that didn't work either.

=IF(AND(Complete? = 1, (ISBLANK(Notes1), 1, 2)

=IF(AND(Complete? = 1, (ISBLANK(Notes1), 1, 2)))

=IF(AND(Complete? = 1, (ISBLANK(Notes1), "True", "False")))

I was using 1, 2 because the Notes1 field is a checkbox. Tried using true & false out of desperation.

JoeC.

Hi Deb,

It's the "?" that's messing things up, which I left out of my example. This should work:

=IF(AND([Complete?]1 = 1, ISBLANK(Notes1) = 1), "True", "False")

Deb Gordinier

You are a genius!! Thank you soooo much!!

Paul Newcome

To simplify even further, you can use...

=IF(AND([Complete?]@row= 1, ISBLANK(Notes@row)), 1)

the "@row" looks at whatever row the formula is on, so no need to update numbers unless you are referencing a different row.

the "= 1" isn't needed in the ISBLANK portion.

If you do not specify anything for the third portion of an IF statement, it defaults to 0 (false).

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard not updating
Hello Smartsheet Community! I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students. =IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today",…
Sheet Summary Formula Help
Hello, I am trying to get this formula to work but am not having any luck. When I remove the last @cell….text below the formula works great. When I add it in I get an error. Any ideas? =COUNTIFS([ACCT READINESS STATUS PLV]:[ACCT READINESS STATUS PLV], OR(@cell = "PENDING LOCAL CAH", @cell = "ADDITIONAL REVIEW NEEDED LOCAL…
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…