Week of the Year Formula help

Platform discussions Special workflows & use cases
1

I have a due date column that is a formula derived from down payment date x weeks of lead time. I also have a hard ship date in case sales has made a promise we have to keep. The hard ship column will be empty the majority of the time. I need the week number populated into a column for the earlier of the 2 dates if there are 2 dates and just the week number of the due date column if there is only one date. My formula is not working. Can anybody educate me about why it isn’t working and what I need to do to fix it?

Here’s my formula -
IF(ISBLANK({HARD SHIP}), WEEKNUM({Due Date}), WEEKNUM({HARD SHIP}))

image
image1355×156 28.1 KB

2

Is your due date column a date column or a formula column? I believe you’ll need to change it to a date column to make it work.

3

It’s a formula.

Gina Welch
Girl Friday Extraordinaire
501-580-3361

4

Try:

IF({Hard Ship}="", WEEKNUM({Due Date}), WEEKNUM({Hard Ship}))

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

5

That worked!!! Thank you! Can I add the year to that week number that is resulted?

6

You can use Concatenate but the formula would look a bit too long. It would look something lik this.

Concatenate(IF({Hard Ship}="", WEEKNUM({Due Date}), WEEKNUM({Hard Ship}))," ",IF({Hard Ship}="",FORMAT_DATE({Due Date},"YYYY"),FORMAT_DATE({Hard Ship},"YYYY"))

7

Or…

IF({Hard Ship}="", 
  WEEKNUM({Due Date}) & " " & FORMAT_DATE({Due Date},"YYYY"),
  WEEKNUM({Hard Ship}) & " " & FORMAT_DATE({Hard Ship},"YYYY")
)