Need a formula that works like a report -- date is within the last 30 days
I've been looking through the Community and can't find this...sorry if I've overlooked.
I have a series of reports that determine if certain projects are within the last 30 days, such as added in the last 30 days, go live in the last 30 days, completed in the last 30 days, etc. This is very easy to do on a report and get a list of all the projects that fit this criteria. However, I'm trying to create a dashboard with metrics, and I can't seem to recreate this summary in a formula.
Let's start with an easy one. I have a column that is Go Live. I want to do a COUNTIF for all projects where the Go Live date is within the last 30 days. Is this possible to do? Or do I need to add an additional column on my spreadsheet to check there and just add the checkboxes?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!