Creating an Age Pending report

Beronica Muller

I am fairly new to Smartsheet and trying to create an age pending report. I have used the =IF(Submitted By = 1, 0, (Created1 - TODAY())), and receiving an error message. Could someone assist me with this please?

Paul Newcome

Whenever you have a space, number, or special character in a column name, it needs to be wrapped in square brackets when placed in a formula. You also need a row reference.

=IF([Submitted By]1 = 1, 0, (Created1 - TODAY()))

Paul Newcome

Whenever you have a space, number, or special character in a column name, it needs to be wrapped in square brackets when placed in a formula. You also need a row reference.

=IF([Submitted By]1 = 1, 0, (Created1 - TODAY()))