Convert Column Syntax Error

Dennis 70s Kid
edited 04/12/24 in Smartsheet Basics


I am trying to use the formula =TODAY() - [Date Submitted]1 to make a column for {AGE in days} since a form was submitted. I am not the best at formulas but really want to base some automations on days old for sales management and KPIs

Like this

It works for one row but when I try to convert to column formula like this:

I get this error:

Currently it is working for one row like this:

Thanks in advance,

Dennis Baughman

Midtown Signs