SUMIFS Questions

asowersLGE

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?

asowersLGE

@Julie Fortney , thank you! I was not aware of this feature.

Julie Fortney

Hi @asowersLGE. It sounds like you could use a report for this. Set your source as your project import sheet, display any columns you would like, then set a filter that pulls in rows with a date between 1/1/22 and 12/31/22.

You can then use the Summarize option to display a sum of the Overall Cost column.

www.linkedin.com/in/juliefortney-pmp-smartsheetpartner-lssblackbelt

asowersLGE

@Julie Fortney , thank you! I was not aware of this feature.