Checkbox dependent on data in two rows.
I Regularly refresh different databases throughout the year by making a copy of the old one and importing the new data into it. This results in a ton of redundant data, and I'm looking to quickly cull.
After sorting my grid by IDNumber, how can I get the "To Delete" column to automatically check in rows that have identical "IDNumber" ("duplicate ID" would be checked) and "Location" entries, but "NewEntry" is NOT checked?? (rows 2 & 11).
Similarly, how could I get "Location Change" to automatically check in a rows that have duplicate "IDNumber" values ("Duplicate ID" would be checked) and "NewEntry" is checked, but the "Location" values are different? (rows 3 & 8).
Answers
-
For your Location Change checkbox, what would determine which of the two get's that box checked or would they both get checkmarked?
What would determine which one gets New Entry checked? If two sheets are merged with Copy Row into a new sheet, the new sheet's modified/created date will be new and not when they were entered wherever they came from.
-
After I import the new data, I simply check the new rows in the new entry column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!