Multi-select dropdown + IF-formula

Hi there,

Hope you can help me. In a help-column (Help3) I want the system to return either "Behandling", "Forskning" or "Begge" based on selections in a multi-select dropdown in CHILDREN-rows.

If only the choice "Behandling" is selected in the multi-select dropdown column called "Formål" for any of the CHILDREN rows the system should in the PARENT row return "Behandling".

If only "Forskning" or "Kvalitet" is selected in the multi-select dropdown column called "Formål" for any of the CHILDREN rows the system should in the PARENT row return "Forskning".

If both "Behandling" AND one of either "Forskning" OR "Kvalitet" is selected the system should in the PARENT row return "Begge".

Hope this makes sense?

Sorry I'm new to smartsheet and this is as far as I can get: =IF(HAS(Formål@row; "Behandling"); "Behandling")

Thank you in advance,

Anne

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @AnneOUH,

    I think this formula does what you would like:

    =IF(AND(HAS(CHILDREN(Formål@row), "Behandling"), NOT(HAS(CHILDREN(Formål@row), "Forskning")), NOT(HAS(CHILDREN(Formål@row), "Kvalitet"))), "Behandling", IF(AND(NOT(HAS(CHILDREN(Formål@row), "Behandling")), OR(HAS(CHILDREN(Formål@row), "Forskning"), (HAS(CHILDREN(Formål@row), "Kvalitet")))), "Forskning", IF(AND((HAS(CHILDREN(Formål@row), "Behandling")), OR(HAS(CHILDREN(Formål@row), "Forskning"), (HAS(CHILDREN(Formål@row), "Kvalitet")))), "Begge", "")))

    Examples below - I am not sure what desired result you would like for test cases 6 & 7 though:

    If these don't come up, then they won't be an issue but if they do and should have different outcomes, please advise and I can adjust the formula to reflect this.

    Hope this helps, if you have any questions etc. let me know! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!