Help with multiple IF formula


I am wondering if someone can help with a formula please.

I have two date columns which lookups to a cell and gives it a start date and an end date. Which is usually a start of the month and end of the month date.

I need a formula that looks at 'Date Completed' and if it is within the start date and end date then it say "Completed in Month" . If the 'Date Completed' is outside of the start date and end date then it is 'Not Completed in Month'. If the 'Date Completed' is blank then it says nothing.

Thank you.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!