+9Hi 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’)))
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’)
+9Thank you thank you!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.