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?
Help Article Resources
Check out the Formula Handbook template!