How can I trigger an IF statement only once?

Bobert

I have a column that is a single select drop down menu. We use this to keep track of who is responsible for that line as the project moves through our departments. A couple of the selections are outside our company. We want to record in a separate column who the outside contractor is. I am attempting to copy the name of the outside contractor from the responsibility column to the outside contractor column the first time it is selected. Once it is copied into the outside contractor column I don't want to overwrite it again. I attempted to use IF statements and Automations, but I am unable to get it to work. Any help would be appreciated. Thanks.

Andrée Starå

Hi @Bobert

I hope you're well and safe!

How many Outside Contractors could you have?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bobert

The drop down has about 15 selections. 3 of those are outside contractors. We're trying to keep track of which outside contractor is working on the project, so that even when the work comes back, we know which one we sent it to.

Andrée Starå

@Bobert

I'd recommend using a Workflow combined with the Assign People Action or similar.

Would that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!