Can I not use formula columns in Summary formulas?

I am trying to do counts of cards/rows with various ages so I can show how long some things have sat in our backlog. I created a date column that uses the date received, system generated info and just puts a date for "created" to try to get the formula in summary to work but I still get "unparseable". Here is my formula: =COUNTIFS(Status:Status, "Backlog", [Created:Created], > TODAY() - 180)

How do I get this information?

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

    Instead of

     =COUNTIFS(Status:Status, "Backlog", [Created:Created], > TODAY() - 180)

    Put the -180 days into the brackets after TODAY, like this

    =COUNTIFS(Status:Status, "Backlog", Created:Created, >TODAY(-180))

    This is the syntax I use with TODAY in smartsheet. The number of days to add or subtract go inside the parenthesis.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!