Sheet Summary Column Formula - Created = Today - 7



How would I create a summary of [Column A] for all rows that were created 7 days ago?

I tried this, but it didn't work.

=SUMIF(Created:Created = TODAY(-7), [Column A]:[Column A])

Response was: Invaild Operation

Please assist.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!