#### 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.

# Error while transfering a formula from Excel to Smartsheet

Options
edited 12/09/19

Hi!

Someone tried to transfer a formula from excel to smartsheet... The only problem is that the formula is quite long and there is one/multiple error(s) left.

Can someone help? I've found a few ones ( ; instead of , ... WEEKNUM instead of WEEKNUMBER) but I can't get it to work...

Here it is. I colored the different if parts to help when looking at the formula.

=IF(ISBLANK([Kick off Date]51),"",IF(WEEKNUMBER(IF(YEAR([Kick off Date]51+([Timing (weeks)]51*7))-YEAR([Kick off Date]51)=1, [Kick off Date]51+((([Timing (weeks)]51+2)*7), [Kick off Date]51+(([Timing (weeks)]51*7)),1))>51,IF(YEAR([Kick off Date]51+(([Timing (weeks)]51*7))-YEAR([Kick off Date]51)=1,[Kick off Date]51+((([Timing (weeks)]51+2)*7), [Kick off Date]51+(([Timing (weeks)]51*7))+(2*7),IF(YEAR([Kick off Date]51+(([Timing (weeks)]51*7))-YEAR([Kick off Date]51)=1, [Kick off Date]51+((([Timing (weeks)]51+2)*7), [Kick off Date]51+(([Timing (weeks)]51*7))

Tags:

• Employee
Options

Hi Etienne-- Would you be able to share this sheet (or a copy) with me at Kennedy.Stomps@Smartsheet.com? I'll be happy to help troubleshoot once I can get a better look at it

• ✭✭✭✭✭✭
Options

This section (near the end of the IF in the WEEKNUMBER)

Date]51+(([Timing (weeks)]51*7)),1))>51,IF(YEAR([

looks odd.

If you could put it into words what you are trying to accomplish, the formula might be simpler to write.

Craig

• Options

My problem is that I actually don't know what they want that formula to do... Someone that doesn't know how it's supposed to be used gave me an excel file containing it and told me to translate to smartsheet...

• ✭✭✭✭✭✭
Options

Does the formula work in Excel?

It looks like it wouldn't, but I don't have Excel to test it on.

Craig

• Options

This is the adaptation of the formula for Smartsheet... The excel formula works fine.

• ✭✭✭✭✭✭
Options

Can you post the Excel formula?

It might be easier to fix.

Craig

This discussion has been closed.