Convert Column Syntax Error

Dennis 70s Kid

Hi,

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

Andrée Starå

Hi @Dennis 70s Kid

I hope you're well and safe!

Try something like this. (you can't use direct cell references in a column formula)

=TODAY() - [Date submitted]@row

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dennis 70s Kid

That is what I needed. Thanks!! Works like a dream and am using it across a bunch of sheets already.

Andrée Starå

@Dennis 70s Kid

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!