I would like to create an if statement and could use some assistance …
If cell A is not checked, outcome “planned”
If cell A is checked, outcome "in progress
If cell B is checked, outcome “complete”
I hope this makes sense. Thank you for any help yo...
As you can tell by my question, I am new to Airtable :slightly_smiling_face:
How do I rewrite this formula so it does not result in …#ERROR when I don’t have dates in some the cells used in the calculation? I would rather have that cell remain bla...
Sounds good! I know if I put some effort into it, I would really enjoy “solving” these formulas. I will check out your youtube page. Thanks again for all your help, Justin!
Justin_Barrett:
IF(Done1, IF(Done4, "Complete", "In Progress"), "Planned")
Perfect, worked like a charm! I’d like to get better at understanding and writing my own formulas. I have read over some of the stuff on the airtable support page. B...
Well what you can’t see are the fields I hid so that the critical parts would show on the screen for you. These Done columns relate to promotion dates. Once they are promoted then our social media manager is supposed to check them off. I would en...
Thanks again for all your help! What I would like to happen is…When DONE1 is checked the outcome in Calculated Progress would be “In progress”. When nothing is checked, it is “planned”. Once DONE4 is checked the outcome would be “complete”
Justin_Barrett:
IF(NOT({cell A}), "planned", IF({cell A}, "in progress", IF({cell B}, "complete")))
Thank you Justin! I didn’t get any errors using this formula but the outcome is not working like I thought it would. The complete outcome do...
