If checkbox checked, replace text content in another column

Suzanne Raphael

There is a text column (AAA) that contains a URL. If a checkbox in the column "BBB" is checked, that URL should be replaced with "In the DB." I've tried using a 3rd formula-devoted column, but so far no love.

How??

Andrée Starå

Hi @Suzanne Raphael

I hope you're well and safe!

You could use a Workflow combined with the Change Cell Action, and when the checkbox gets checked, it will change the cell to "In the DB".

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Andrée Starå

Hi @Suzanne Raphael

I hope you're well and safe!

You could use a Workflow combined with the Change Cell Action, and when the checkbox gets checked, it will change the cell to "In the DB".

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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!

Suzanne Raphael

That will do it, thanks Andrée!

Andrée Starå

@Suzanne Raphael

Excellent!

Happy to help!