When "Connect Done" and "Core/Micro Done" are both checked, I want "Client Done" to automatically be checked.
Can someone help me with the formula? I'm guessing its an =IF
Try something like this.
=IF(AND([Core/Micro Done]@row = 1; [Connect Done]@row = 1); 1
The same version but with the below changes for convenience.
=IF(AND([Core/Micro Done]@row = 1, [Connect Done]@row = 1), 1
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic weekend!
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 PARTNER & CONSULTANT / EXPERT
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
it says unparseable both suggestions. Any other thoughts?
Are the column names correct? Core/Micro... Done?
oh, that was the problem, the column name was shortened, thanks! but now to drag this down to all the other rows, its keeping the row=1. How do I copy it so the formula changes for each row?
Should the 1 change?
Oh, it actually works even the formula says row=1, why is that?
The 1 = Checkbox is checked.
Thank you so much! This saved a bunch of time...
You're more than welcome!
✅Remember! 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!