A formula structure that controls 4 different columns at the same time

I have 4 different formula columns and each shows me the next week. And also I have a checkbox column where I give approval for each week. If one of them is not ticked, I want it to say “you cannot plan this week” for the unticked column in the formula column. But if I use the If formula, it checks whether there is a tick in the first column but not the others. What kind of formula should I write to check the others as well?

Hey @Ezogurr,

Would you be able to send a screenshot of the 4 columns and the specific formulas you’re using? This will help us do some testing on our end and understand where the roadblock is.

Thanks :pray: