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))
