How to make formula which adds when not TBD

Joshua Baer over 8 years ago

Im trying to find help on a formula for building a field which adds to fields if one does not contain the letters TBD.

If Field XYZ is not TBD, then add Field XYZ and Field ABC.

0 Megan Sheehan over 8 years ago

You should be able to accomplish this with an ifElse statement in a calculated field. Something like:
ifElse(equal($fieldXYZ,"TBD"),"",add($fieldXYZ,$fieldABC))

Business Analyst

Technology Advisors, Inc.
0 Joshua Baer over 8 years ago in reply to Megan Sheehan

Perfect. Thank you! I had forgotten the quotes and couldnt recall how to write that out correctly. Much appreciated.