Returning the value in a corresponding cell that returns the largest number in Sheet Summary


I have been able to return the largest number for a specific day in the sheet summary using =LARGE(COLLECT([Profit]:[Profit], Date:Date, =Date#), 1) but I am having trouble returning the corresponding transaction number for the returned value of the above formula. I want to be able to return the transaction number in another line in the sheet summary.

Thanks in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!