Sheet Summary Column Formula - Created = Today - 7

Options

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!