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

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?

Answers

  • Ramzi K
    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

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!