Calendar / Calculation column

yevgeni.rchichev43536

Hi,

can anyone help me with the following?

I need to have a column in my sheet which can be a calendar column and a regular number calculation column at the same time. I need to be able to calculate number of days between start and finish dates, but also to have the option to deduct a number from another number.

 

Thanks!  

Andrée Starå

Hi Yevgeni,

There isn't a way to combine them but you can calculate or deduct days in another column. Would that work for you?

Please see attached link/screenshot.

https://help.smartsheet.com/function/today

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

yevgeni.rchichev43536

Hi Andrée,

not really, since in my sheet each client is a column where we register sales, but also need to enter ETA date and calculate a deadline date for production.

 

But thanks anyway!

Y.

 

Andrée Starå

Ok.

Could you change, so the client is on the row instead?

If you want you can upload a screenshot or share the sheet with me so that I can easily see if I can come up with a solution.

Best,

Andrée