How to write an "IF" formula involving a checkbox and drop down.
I'm trying to write a formula stating if the "Done" column is checked, then "Status" is complete, but keep getting #unparseable errors. I'm trying to avoid having to click "Done" and also change the status manually to complete.
I'm incredibly novice with formulas and would greatly appreciate an assist!
Best Answer

Hi Taylor,
I can help you with the formula, but there may be an issue with implementing it if you have any other Status other than complete. I'll show the formula then talk through why it might be problematic. This formula would need to go in your Status cell.
=IF(Done@row = true, "Complete")
The potential problem is that you've now coded a formula to look at a single condition for Status. That means that no other change will automatically occur on the Status column, and if anyone manually puts in another status the formula will likely be written over.
Could you do the opposite and check the Done box if the Status is Complete? This sounds like it would be more fool proof:
=IF(Status@row = "Complete", true)
Answers

Hi Taylor,
I can help you with the formula, but there may be an issue with implementing it if you have any other Status other than complete. I'll show the formula then talk through why it might be problematic. This formula would need to go in your Status cell.
=IF(Done@row = true, "Complete")
The potential problem is that you've now coded a formula to look at a single condition for Status. That means that no other change will automatically occur on the Status column, and if anyone manually puts in another status the formula will likely be written over.
Could you do the opposite and check the Done box if the Status is Complete? This sounds like it would be more fool proof:
=IF(Status@row = "Complete", true)

That works, thank you for both options. They make complete sense. Appreciate the quick response!

No problem, glad it helps
Help Article Resources
Categories
Check out the Formula Handbook template!