Automatic Checkbox Based on 3 Sets of Dates

Options

I'm trying to get a checkbox to check automatically if the day in progress is within a given month, but has not been completed in the same month and has not been placed on hold after the day in the month that it was placed in progress. Any help would be grateful!!


If the project was dated as "In Progress" on 6/15/2022 (helper date column already created for date in progress)

Completed date was not in June or before June (helper date column already created for date completed)

On Hold date is not equal to 6/15/2022 or between 6/15/2022 and 6/30/2022 (helper date column already created for date on hold)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!