Sumif by Year

Options

The formula that works is

=SUMIFS({Client Termination Worksheet Range 2}, {Client Termination Worksheet Range 1}, "Colby Bolinger", {Client Termination Worksheet Range 4}, NOT(@cell = "Completed Exit"))

I need to add something to this to only show values in a date column which are for the current year.


Thank you for your help in advance.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!