Automate manual data entry
Best Answer
-
You can use a COUNTIF formula to check a box if there is a count of 1 (or more) of your criteria across sheets. For example, put this in Sheet 2:
=IF(COUNTF({Work Order Sheet 1}, [Work Order Number]@row) > 0, 1, 0)
This looks through your Work Order Number column in Sheet 1 and checks to see if the current Work Order Number in this row (of Sheet 2) appears in that sheet. If it does, all is well and it checks the box. If there is no instance, it will return 0, or an unchecked box.
Then once you have this indicator on each row, you can set up a Copy Row workflow that checks the sheet once a day to copy over rows that have an unchecked box, like so:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
You can use a COUNTIF formula to check a box if there is a count of 1 (or more) of your criteria across sheets. For example, put this in Sheet 2:
=IF(COUNTF({Work Order Sheet 1}, [Work Order Number]@row) > 0, 1, 0)
This looks through your Work Order Number column in Sheet 1 and checks to see if the current Work Order Number in this row (of Sheet 2) appears in that sheet. If it does, all is well and it checks the box. If there is no instance, it will return 0, or an unchecked box.
Then once you have this indicator on each row, you can set up a Copy Row workflow that checks the sheet once a day to copy over rows that have an unchecked box, like so:
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
This works! Thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives