Using result from one check box to check another box
The trigger box is a checkmark, the receiving box is a star. I'm using this formula:
=IF ([ShipC Updated]@row = 1), 1
The column name is ShipC Updated, the column I'm putting the formula in is Complete (has the star). I'm getting #Unparsable errors regardless of what I try! Please help!! Snip of spreadsheet below. Both columns are checkbox columns.
Thank you!!
Best Answers
-
Hi @ReneeW
I hope you're well and safe!
Try something like this.
=IF([ShipC Updated]@row = 1, 1)
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Excellent!
You're more than welcome!
You were off with the space at the beginning and the parenthesis at the end.
=IF_([ShipC Updated]@row = 1), 1
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
@ReneeW Have you tried replacing the 1 with the word true? That is what a checkmark usually represents. (No quotes needed.)
dm
-
@Dale Murphy I appreciate the quick response! That doesn't seem to work either.
-
Hi @ReneeW
I hope you're well and safe!
Try something like this.
=IF([ShipC Updated]@row = 1, 1)
Did that work/help?
I hope that helps!
Have a fantastic week & Happy Holidays!
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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå A think of beauty! Thank you so much! I'd tried other posts by you so don't know where I was "off" exactly, but I copied and pasted yours into the cell and voila! Happy Holiday to you, as well. Renee
-
Excellent!
You're more than welcome!
You were off with the space at the beginning and the parenthesis at the end.
=IF_([ShipC Updated]@row = 1), 1
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Thank you for the clarification. Very helpful!!
-
I'm always happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå One more question. We are using Workflows to automate alerts on certain report conditions. This one seems straightforward to me, and does return the alert, however, it returns for other rows where the date condition doesn't exist ... meaning, there are comments in the first couple of rows so the columns are still present. However, the date field is not populated to meet the first condition. What are we missing?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!