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?
Comments
-
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")
-
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.
-
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")
-
You are a genius!! Thank you soooo much!!
-
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).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!