Countif value matching from multiselect cell


Please help, i have 2 sheets. One sheet contains week no. i.e. the week in which a member is absent. I wanted to count week numbers from that column only if week number is mentioned in other sheet under (multi select cell). Ì used this COUNTIFS({Team Vacation Planner Range 2}, [Assigned To]@row, {Team Vacation Planner Range 1}, CONTAINS([Week Number]@row, @cell)) but it's not working.

Tags:

Answers

  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭

    @Preeti Kumar I'm not sure why you are using COUNT, so I may miss your point.

    This seems to work. It returns a 1 when it sees a match, but zero when [Non working] is not found in [Week Number].

    (replace [Non Working]3 with [Non Working]@row to generalize.

    Does that get you what you want?

    Cheers,

    Dale

  • Hey Dale,

    Thank you so much for the help. Sorry for the confusion, i basically wanted to sum the number of days a person is absent from the weeks mentioned in multiselect cell. Just getting yes or no will not help me :-(.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!