Calculating days that contacts, in a contact list field, are listed.

Murilo Masson

Dear smartsheet masters,

I do have a sheet that I document event name, how many days this event takes, contacts to be scheduled for this event.

In the majority of the events, I do have only 1 contact to 1 event. However, I might have events where I do have multiple contacts.

Implementing a formula to sum up the days per contact, I am able to cover the 1 event per contact:

=SUMIFS({durationPTO Range 2}, {Trainingdays Range}, =1, {Trainer 2021 Range 1}, =[Trainer Name]1)

However, I am not able to count the days for all contacts in the field. I tried with @row function, but it did not work since I have a field that it is a multiple contacts field.

Is there any idea how can I perform such formula?

Ramzi K

@Murilo Masson

Try using the HAS function to determine if a multi-select cell has the value you are looking for.

Cheers,

Ramzi