Remove error in "Week Of" formula

[Kelly_Vorrasi1]

Hi All,

I’m trying to adjust this formula to state “Needs Mix Date” instead of just showing an error when there is no {Mix Date} filled.

CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’))

I tried this but it’s not working

IF({Mix Date},CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’),’Needs Mix Date’)))

[Claudio]

The first clue is that the formula ends with “)))” but there is only one IF.
That means that you have an extra parenthesis or you have one or more parentheses in the wrong place.

Try this:
IF({Mix Date},CONCATENATE(“Week of”," ",DATETIME_FORMAT(DATEADD({Mix Date},-DATETIME_FORMAT({Mix Date},‘e’),‘days’),‘M/D’)),‘Needs Mix Date’)

[Kelly_Vorrasi1]

Thank you thank you!!