Date Formula

I have a list of people who are working on multiple projects throughout the year. Each project/employee has a different start and end date. My goal is to flag a person who is currently on 3+ projects at once. I used a formula to count the projects each person is on, but I would like to take dates into consideration. For example, how many projects is Employee A on between today and the end of the year. The issue is I need it to automatically update each day to be the current day.

Formulas I used:

=COUNTIF({Project Resources Range 1}, "Employee A") - Which gave me a total project count

=IF([Active Projects]@row>=3,1) - Which flagged rows that had 3+ projects

I need a formula that says in addition to the formulas above, only look for projects from 10/5/22 (I want this date to automatically change daily) -12/31/22.

Is this possible in Smartsheet?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!