Check a Checkbox

Andrea Westrich

I'm working with two columns, "Status" (Dropdown) and "Complete" (Checkbox). I'm finding not everyone checks the checkbox so I'd like to put a formula in that cell that will check to see if the checkbox in "Complete" is unchecked and "Status" is Complete, mark the checkbox. Is that possible?

Mark Cronk

Hi Andrea,

You can use a formula to mark the checkbox when the status is Complete. But doing so will prevent users from checking the box unless they are owners or admins.

Can the checkbox ever be checked when the status is not Complete?

Your formula would be:

=IF(Status@row="Complete", 1, 0)

Mark

Mark Cronk

Hi Andrea,

You can use a formula to mark the checkbox when the status is Complete. But doing so will prevent users from checking the box unless they are owners or admins.

Can the checkbox ever be checked when the status is not Complete?

Your formula would be:

=IF(Status@row="Complete", 1, 0)

Mark

Andrea Westrich

@Mark Cronk, thank you for this information. I'd like users to be able to either check the box or mark status as complete. So instead of the formula that will not allow that option, I wrote a formula to add on points (it's a challenge) if they did either.

I can tell you that your formula worked perfectly and I've made note of it for future use!

Thank you so much for your very complete answer!

Mark Cronk

Creative. Well done. Thank you for contributing to the Community.

Mark