Really simple If statement - value if true doesnt work if value if false is ""

Jacinta ✭✭
edited 11/09/22 in Formulas and Functions

Hi I have a relatively straightforward if statement and it works, but not always.

This is my formula and it works,

=IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "nope")

however if I replace "nope" with other types of values, the whole thing stops working, including the value if true ..

e.g. =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), "") returns blank whether true or false

And =IF(COUNT(ANCESTORS()) = 3, PARENT(Responsible@row), Responsible@row) returns blank when true, works when false

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!