Reference two columns to populate a third

Options

Hi,

I'm fairly new to Smartsheet and am stuck trying to figure out a formula. I have three columns; 'Due Date', 'Complete' and 'Status'. Due is a XX/XX/XX format, Complete is a drop down with 'Yes or 'No' and Status is blank. Here's what I need:

If 'Due Date' is past the current date (today) and Complete = No, then Status needs to populate with 'PAST DUE'

If 'Due Date' equals tomorrow and Complete = No, then Status needs to populate with 'Due Tomorrow'

If 'Due Date' equals 2 or more days from today and Complete = No, then Status needs to populate with 'In Progress'

If 'Due Date' equals any date and Complete = Yes, the Status needs to populate with 'COMPLETED'


Any help is greatly appreciated! I've been struggling with this formula for a couple of days now. Maybe I need more than one formula? I'm not sure.


Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!