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!
Help Article Resources
Check out the Formula Handbook template!