Help with IF function combining multiple columns and greater than today dates
Hello I am trying to write a formula that returns one of the following "Not Yet Started, "In Progress," or "Complete" based on dates being in the past or future and multiple columns.
So I would like the Study Status Prod column to say "Not Yet Started" if the date in the Anticipated Study Start Date column is before today and the Study Status Prod column to say "In Progress" if the date in the Initiation of Study Date column is before today and the Study Status Prod Column to say "Complete" if the Final Report (Target Date) column has a date after today.
Is there a way to write this formula?
Thank you in advance!
Help Article Resources
Check out the Formula Handbook template!