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

Sophie Bown

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)

thanks!

Andrée Starå

Hi @Sophie Bown

Yes, but you’ll need to add the sheet name to a column, cell, or sheet-summary field and reference it in the formula.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Sophie Bown

Thanks Andree, do you mean to have on each of the source sheets with dates an extra column which includes the sheet name? I could definitely do that.

Could you give an example of how I would incorporate that into my formula sheet -

I would use one formula to find the max date across three sheets (easy enough)

Then I need another formula to pinpoint where that max date was found ?

will it be like a multiple vlookup and if statement

I can't quite grasp it...

Andrée Starå

@Sophie Bown

Happy to help!

Yes, something like that.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Sophie Bown

Thanks Andree that's very kind. I might be able to create an example to share next week if possible

Andrée Starå

@Sophie Bown

How did it go?

Did you get something working?