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 information? 👀 | 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 information? 👀 | 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
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives