Count + IF Statement?

I would like to count the days from the 'Date' to the 'Date of Completion' once entered and have the counted days in the 'Turn Around Days' column when the status column is clicked 'Complete'

Something like IF Status = complete and the Date is < or = Date of Completion then Turn Around Days are 6 (in this case)

A million dollars for the correct answer as I have no hair left.

Thank you wizards!


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!