Can I not use formula columns in Summary formulas?

Noelle C

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?

KPH

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.

KPH

Does this work?

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

Noelle C

@KPH Yes!!! That does work! But why?

KPH

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.

Noelle C

Thank you so much!

KPH

Happy to help @Noelle C

If possible, can you click "yes" on the second answer for "Did this answer the question?" to help others find the answer if they have the same question. Have a great weekend!