How do you create a "days remaining until start date" column that will select the start date one eac

Barnabe Geis

Hello! I'm new to Smarsheet and haven't been able to figure this one out. I have a sheet with many tasks that have different start and end dates. I want to create a column that will tell me how many days are left until the start date of each task. This formula works: =[Start Date]23 - TODAY() But I need it to automatically modify itself so that if it is on row 5 it selects Start Date 5, if on 6 it selects Start Date 6, and so on. Each days remaining cell on each row should show number of days until start date on their same row. Please help and thank you! 

 

PS it would be even better if it didn't show negative days but just counted down to zero and then remained at zero. 

 

 

Matt Hines

Your formula should work if you copy and paste and should update the [Start Date] row automatically. If you want to add some less than zero logic then you should just add an IF statement in there like this =IF([Start Date]23 - TODAY() < 0, 0, [Start Date]23 - TODAY() < 0) .