Comparing rows
Team,
I am trying to compare 2 rows that are almost identical, and highlight the differences to take the most update in the same sheet. Yet I am not able to find any formulas to do so. I have tried INDEDX and MATCH but it is not giving me the results I need.
Any help will be much appreciated.
Thank you
Answers
-
Hi @Eddy Deeb
Are you looking to bring this data into a Third Row, or is one of your two rows the one you'll be building the formula in?
Would you be able to post a screen capture, showing your set-up and identifying the rows (and the unique identifier you're using to match them) but block out sensitive data?
We'll likely want to use some sort of INDEX(MATCH(MAX so we can look at the MAX date and bring in data from the row with the most recent date.
An alternative would be to use a Report and Group by your unique identifier. Then you can quickly see rows grouped together and Sort by the Date.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!