Enterprise & Sell

Enterprise & Sell Answers & Best Practices How to make formula which adds when not TBD

Click here to join this group and curate your SugarClub experience.

How to make formula which adds when not TBD

Joshua Baer over 7 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 7 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.
Cancel
Vote Up +3 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Joshua Baer over 7 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel