No problem at all! 🙂
Hi Again Genevieve P. ...
Additional request is to exclude another name from the total.
To exclude one the following worked well:
=SUMIFS([Payment status]:[Payment status], Institution:Institution, <> "Stanford")
How will the formula look to exclude another "name" (Stanford & ICO)
Take a look at the second formula in this post! You should be able to exclude multiple values by using AND(@cell <> "Value", @cell <> "Value)
Thanks Genevieve to you and Arvin from Smartsheet 1:1 support for your help and support!
Wonderful! Glad we could help.
©2022. All Rights Reserved Smartsheet Inc.