Date Formlulas for Dashboard Counter

Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello, Trying to set up formulas from a sheet to post to a dashboard, somehow came up short.  I have a number of projects listed in my sheet with a [Go Live] date. I would like to count the following:

  • Number of projects that are within 30 days of Go Live (but not past go live)
  • Number of projects that are within 7 days of Go Live (but not past go live)
  • Number of projects that have already gone live.   

The last one seems to be working with the formula: =COUNTIF([Go Live]:[Go Live], >TODAY())

The other two, are not working as I could not figure the conditions correctly.  Thanks in advance for any help

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!