Formula most urgent topics with RYG, date

Joerg Schmidt

Hallo,

I want to combine the following columns with a formula in the sheet summary: RYG, date of receipt, comment and hotel

The sheet summary should show

"hotel name" and "comment" if RYG = "red" and (the earliest date of receipt as most important aso.)

Hope you can help again ;-)

Paul Newcome

Are you able to provide a screenshot with the desired outcome manually entered so we can see exactly how your sheet is set up and what you are trying to accomplish?

Paul Newcome

Are you able to provide a screenshot with the desired outcome manually entered so we can see exactly how your sheet is set up and what you are trying to accomplish?

Joerg Schmidt

Dear Paul,

I just realized by myself how simple the solution is. I created a report and transferred the data into a dashboard. Ready!

Thanks for helping ;-)

Paul Newcome

Happy to help. Glad you were able to get it figured out. 👍️