Using a formula with parameters that are calculated in RIGHT/LEFT function

Corentin Dal Farra
Corentin Dal Farra ✭✭✭✭✭✭
edited 11/30/20 in Smartsheet Basics

Hello everyone,

I have a problem with one formula and I do not know how to correct it :

I have a sheet with four columns :

  • First one : the date in text format Year-Week number
  • Second column : extract year
  • Third column : extract week number
  • Fourth colmun : calculate an automatic date

I would like to use a formula that automatically calculate the date when I put a value in the first column. Currently I have to put manually year and week number..

When I try to do a LEFT function to get only the year for example, the formula in the fourth column do not work anymore.

Do you know how to bypass this problem ?

Thank you, have a great day,


Best Answer