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

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

Making mistakes is the fastest path to excellence.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!