Checkbox formula using =IF(OR

I am trying to get thise statement to work when Monday-Complete through Friday-Complete boxes are checked. I've tried replacing =1 with ="Checked", ="Complete", ="Done" and none of them are working.

=IF(AND([Occurance:]1="Daily", [Monday - Complete:]1=1 [Tuesday - Complete:]1=1, [Wednesday - Complete:]1=1, [Thursday - Complete:]1=1, [Friday - Complete:]1=1), [Task:]1)

@Paul Newcome I feel like this is an easy answer. :I

Hello @Paul Newcome!

I'm wanting a checkbox to automatically check if another column is answered in a specific way. Can you help me with an accurate formula for this? I've read everything I can find and can't quite get the right formula down. Thanks so much!

Here's where I'm at, by borrowing other's answers:

=IF ("Are you a:", $[Foreign National]@row) >= 1

Hi @Andrée Starå!

Unfortunately, that didn't work for me. I'm needing the checkbox to check if the "Are you a:" column = "Foreign National". Please let me know what else I need to clarify.

@CMI Director

Ok.

Try something like this instead.

=IF([Are you a:]@row ="Foreign National" , 1)

Did that work?

Hi @Rocky Arnold (760)

I hope you're well and safe!

1

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some bigger screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

2 You can use the new column formula feature.

Would that help/work?

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 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!

@Paul Newcome or anyone who has knowledge on this matter.

In formula:

=IF([% Complete]@row < (85), 1, 0), when formula first added at 84% the flag checkbox ticked expectedly as seen. When I change to 86% the flag is not cleared but remains ticked (red). Is my formula wrong or a bug?

FYI: I tried using the Alert against a simple Target End date, Today(14) formula and it ticks and clears as the date is modified in/out of the 14 days. Eventually I will create a formula that will combine both the percent and date conditions.

@Paul Newcome That's awesome Paul - thank you! I never would have figured that out!