Don’t know why this formula is returning #UNPARSEABLE

gamgc ✭✭✭✭
edited 02/04/23 in Formulas and Functions


This is probably really basic and I’m sorry if it is, but I’ve been tearing my hair out over WHY SmartSheet is complaining about this formula:

=IF(AND([Raised by]@row<>”My Name”,[Raised by]@row<>””),[Raised by]@row)

So - return the column “Raised by” in this row, if it’s not “My Name” and not the email version of “My Name”.

It worked fine without the AND, but I am flummoxed as to why it now has a problem. Before you ask - yes - I’ve tried manually reconstructing the formula by removing and re-adding the cell references with the cell value in the row. Furthermore, it seems to recognise each syntactic element in the expression(s) correctly, so I just cannot see the problem here. I hope someone can.




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!