Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reference a row by Task Name instead of by the row Number.
Here is my challenge. I would like to create a formula in a template based on a row's Task Name (Task Name is a column), not the actual Row Number. The Row Number for this Task Name may change from proejct to project so I cannot reference the Row Number.
The formula is pretty simple. I have a Completion Date column and a Start Date column. When a Completion Date is entered in one row, I want the Start Date populated with that same date in another row.
The task list is very simple with no dependencies.
Thank you for your help!