If this then that formula  what am I doing wrong?
Best Answer

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.
Answers

You need to use a row reference and some type of argument.
=IF([Column name]@row = "Text", "Output")

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
Making mistakes is the fastest path to excellence.

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.
Help Article Resources
Categories
Check out the Formula Handbook template!