is there a formula to identify the source sheet for the maximum value?

Hi there, we are tracking building compliance inspections for a range of buildings and inspection types.

I will write a formula which checks three lists of dates to return the most recent inspection date for a particular building.

Is there any way to have a formula pull through the name of the sheet on which it found the maximum date?

I thought it might be possible as the sheet reference appears automatically on reports.

(NB It is not possible for us to put all the dates and inspection types onto one sheet)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!