If this then that formula - what am I doing wrong?

John Michael (Mike) Munsil

=IF([Existing or Prior Client?]"Yes",3, IF(Existing or Prior Client?]"Don't Know",0,IF(Existing or Prior Client?]"No",-1)))

Paul Newcome

Yes. If you have a specific row number it cannot be used as a column formula. You have to use "@row" references in column formulas.

Paul Newcome

You need to use a row reference and some type of argument.

=IF([Column name]@row = "Text", "Output")

John Michael (Mike) Munsil

Thank you!

This is what I ended up with:

=IF([Existing or Prior Client?]1="Yes", 3, IF([Existing or Prior Client?]1="Don't Know", 0, IF([Existing or Prior Client?]1="No", -1)))  PARSEABLE but cannot convert to Column Formula

=IF([Existing or Prior Client?]@row="Yes", 3, IF([Existing or Prior Client?]@row="Don't Know", 0, IF([Existing or Prior Client?]@row="No", -1))) PARSEABLE and CAN convert to Column Formula

Paul Newcome

Yes. If you have a specific row number it cannot be used as a column formula. You have to use "@row" references in column formulas.