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

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,

Corentin

Find more posts tagged with

Accepted answers

Nicolás Trejo

Hello, @Corentin Dal Farra

Maybe it is not working because you need to convert the texts into numbers using the VALUE() function. It would be something like this:

Debut Livraison Annee: =VALUE(LEFT([Semaine RBàL Livré]@row, 4))

Debut Livraison Semaine: =VALUE(RIGHT([Semaine RBàL Livré]@row, 2))

Beware if you have some input like 2020-3 (week with just one character).

Regards!

All comments

Nicolás Trejo

Hello, @Corentin Dal Farra

Maybe it is not working because you need to convert the texts into numbers using the VALUE() function. It would be something like this:

Debut Livraison Annee: =VALUE(LEFT([Semaine RBàL Livré]@row, 4))

Debut Livraison Semaine: =VALUE(RIGHT([Semaine RBàL Livré]@row, 2))

Beware if you have some input like 2020-3 (week with just one character).

Regards!

Corentin Dal Farra

@Nicolás Trejo

Thank you very much for your answer !

I have spent so much time on this without finding a solution..

Again thank you !

Corentin

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.