COUNTIF and AND formulas

Need to count a number of times a date is less than or equal to a specific date and equal to a value in another column


For example, I have a column "Schedule Status" that is a drop down with either "Completed" or "Scheduled" as choices. I also have a column for start date.

I want to calculate how many dates are less than or equal to 03/31/20 and meet the criteria "Scheduled"

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!