Can i copy a row one time when criteria is met or will this happen constantly?
Hi im trying to automate my works sheet so that when criteria is met, a row is copied to another sheet automatically… my concern is that when that criteria is met, i will get numerous duplicate copies- is that correct? Is there a work around?
Answers
-
If you are wanting the row to copy only once when the criteria is met, you can accomplish this by adding conditions. For ease of knowing which rows have met the criteria you can use a helper column that updates when the criteria is met. You can go this through an automation or through a formula. If you do it through a formula, you can use this helper column as your trigger.
-
that make sense- what would the helper column look like? Would it update with a date? What kind of formula would give me that?
-
Without knowing the criteria being met it's vague, but could be something like this:
Helper column with formula:
When Column1 is updated check box in ColumnB (formula could be something like =IF(ISBLANK(Column1), 0,1) The formula would go in check box ColumnB.
Automation:
Put your criteria in the automation and once the row is copied have a helper column update. This could be a box that is checked, a status that is updated, or a date being captured. You would make that as a condition. The layout would be something like:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!