Multiple conditions withing an IF formula
I am extremely new to smartsheet and I'm having problems understanding the formatting for multiple conditions within an IF(AND()) formula.
I want to have a status show complete only when multiple columns are filled in.
So far I have the date =IF([Date Complete]@row = TODAY(0), "Complete")
The issues comes when I have to add text as well as approved conditions.
The columns are as follows that I need filled first to reach my end goal
Trainee Initials - text
Trainer initials - Text
Trainer Approval - Dropdown (approved)
Training Department Approval - Dropdown (approved)
The dropdown I believe would be
=IF(AND([Date Complete]@row = TODAY(0), [Trainer Approval@row] = "Approved", [Training Department Approval@row] = "Approved", "Complete"). I'm just not sure how to include initials or even if what I have is correct.
It's going to be converted into a column formula and the approvals are automated. Once everything for that task is complete, the status would change and the whole role becomes green.
Any help is greatly appreciated. Thank you!
Help Article Resources
Check out the Formula Handbook template!