Sign in to join the conversation:
Good afternoon, is there a way to change a cell value when multiple conditions are met? Instead of "or" is there an "and"? We have 5 check boxes , that when they are checked we want the 6th one to automatically check itself. Thank you
Hi @BESP10
I hope you're well and safe!
You can either add multiple And conditions to change a cell workflow (click on the Or) or use a formula instead.
Would that work/help?
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!
thank you @Andrée Starå but we cant seem to change the "or" to "and" are we doing something wrong?>
@BESP10
Happy to help!
You'd need to use the Condition area instead.
Make sense?
✅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!
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
This is pulled from a column of responsible person. Why does it display email and not name. How do I correct?
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
