Creating a formula for Text

Viewing 2 reply threads
  • Author
  • November 9, 2017 at 3:29 AM #25832

    Roger Cuthbert

    Hoping someone can help me here.

    I have three fields that all contain either yes or no in them.

    I would like to create a forth calculated field that contains a Yes is any of the other three fields have a yes and a No if all three field contain No.

    Is that possible please?

    Any advice greatly appreciated.


    November 9, 2017 at 11:41 AM #25836


    Hi Roger,

    Are those 3 fields checkmark fields? If so then you can do it like this:

    IF (Check1 + Check2 + Check3 > 0, “YES”, “NO”)

    The value of a Checkmark that’s selected will be 1. The value of a Checkmark that’s not selected will be 0.

    So if any of the Checkmarks is on, you’ll at least get a 1 value and YES will be returned. The only other option is that all 3 are off so then you’ll get a NO returned.

    Set the Result Type to Text for this to work.

    I confirmed that this does work.



    November 11, 2017 at 1:31 AM #25861

    Roger Cuthbert

    Thanks for that. Works as I had wanted.

Viewing 2 reply threads

You must be logged in to reply to this topic.