Is there a limit to the number of fields I can use in a trigger for an automation?

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.

All comments

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!

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?

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?

That might be more difficult.

Let me think about it.

I'll get back to you soon.

How often should the automation trigger?

Hi @Andrée Starå

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?

Thanks for checking on this, @Andrée Starå ,