Formula to return data from last row of a sheet of data

Jed Rusyniak
Jed Rusyniak ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am working on a dashboard and I'm using a intermediate sheet to collect data from other sheets of data.   Typically the data is entered in each day so I was able to have the formula for most cells to look at the referenced sheet and return the value for the row of data by date =SUMIFS({Incidents YTD}, {Yesterday}, "1").  The problem that I am running into is that some facilities don't update the sheet every day (including weekends) so on Monday's the formula doesn't work because it is looking for data from Sunday and there isn't any.  Is there a formula I could use instead that would just look at the referenced sheet and return values from cells in the last row of data?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!