SUMIFS Questions

I have a dashboard that I created and it references several sheets.

I would like my metrics sheet to reference my project import sheet. Check the end date column and if it is from the year 2022, take the column for overall cost and provide a sum of those rows.

Hopefully that is clear on my intent. Can anyone help me?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!