I am new to Smartsheets and I am trying to show how long a task has been open since the project Start Date, but, if the task is marked as "closed", I want the "Days Open" column to record the Date Completed minus Start date, but if task is still Open or In progress, I want the "Days Open" column to record the number of days from start till today.
I have a formula which can calculate the days since the task starts, but of course it continues counting the days even after the task is marked closed. Please help.
=TODAY() - [Start Date]@row