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
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
-
This works! Thank you!