Is there a limit to the number of fields I can use in a trigger for an automation?
I have a sheet that has 50ish columns and I need to copy a row (for archiving purposes) when one out of 25 columns for this row is changed.
It seems like there is a limit to 20 triggers per automation - is this correct?
Is there a way around this limitation?
Yes, I could create one automation with 15 and another one with 10 triggers, but I guess that this would result into two new rows in the archive rather than just one.
Best Answer
-
Thanks for checking on this, @Andrée Starå ,
I was hoping to avoid multiple workflows because it will result into multiple 'Copy Row' actions, i.e. multiple entries in my helper sheet which has doubled to become my archive file for each time the status of a project is updated.
I don't think Zapier is an option - after all, Smartsheet was supposed to be the solution to my workflow management requirements. I'll look into Zapier, though - just to see what it can do in principle.
Answers
-
Hi Werner,
Not sure I follow!
Are you adding 25 trigger conditions in the Workflow?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes, @Andrée Starå - this is what I'm trying to achieve, using 25 trigger conditions; your wording is much more to the point than mine 😉
-
Haha! As long as we understand each other.
I usually say, don't listen to what I say, understand what I mean! 😉
I'd suggest using a so-called helper column instead and a formula that checks for the same conditions if possible.
Would that work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hmmm - not sure how to achieve that.
I'm looking for any change in any of these 25ish columns, i.e. an indication that a project manager has updated anything: be it the number for the '% Complete' info, a text in the 'Achievements for last week' column, or the 'Resource Status' going from yellow to green.
Is there a function for that so that I can create this helper column?
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
How often should the automation trigger?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It's supposed to trigger a 'Copy Row' action, i.e. create a new row in my report archive sheet, whenever a change is made (and saved) to any of the 25 fields in the row.
Sometimes people will only make a change to one field, sometimes they will have updates to 15+ fields or so.
-
I think you'll have to add multiple workflows to make it work.
Another possible workaround could be to use the 3rd party service, Zapier, instead.
Is that an option?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks for checking on this, @Andrée Starå ,
I was hoping to avoid multiple workflows because it will result into multiple 'Copy Row' actions, i.e. multiple entries in my helper sheet which has doubled to become my archive file for each time the status of a project is updated.
I don't think Zapier is an option - after all, Smartsheet was supposed to be the solution to my workflow management requirements. I'll look into Zapier, though - just to see what it can do in principle.
-
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!