Count if project is starting within the next 30 days

Options

Hi,

I'm trying to count how many projects will be starting within the next 30 days. I understand I can filter, but i need to run a report and I'm having difficulty with my formula. I'm fairly new with formulas. I continue to receive a "unparseable" error" . Any help would be greatly appreciated. Thank you in advance.

=COUNTIF({Reference master sheet target start date column}, AND ({Reference master sheet target start date column} <=TODAY(), {Reference master sheet target start date column}<=TODAY (30))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!