NEWBIE Needs Days Aging Help

KristiTRUSD

Hello,

I am very new to Smartsheet and could use guidance. I'm also formula/function challenged! I am able to create the Days Aging function, but I'd like the aging to stop once a completion date has been entered in another column. Is this possible, if not can someone help me with a workaround? I appreciate your help so much!

Paul Newcome

Try something like this...

=IF([Completion Date]@row <> "", [Completion Date]@row, TODAY()) - [Start Date]@row

Paul Newcome

Try something like this...

=IF([Completion Date]@row <> "", [Completion Date]@row, TODAY()) - [Start Date]@row