IF Created time is in week no ... then

Since you’re comparing the same value multiple times, I would recommend using a SWITCH() function. Your formula will look something like this:

SWITCH(
   WEEKNUM(CREATED_TIME()), 
   40, 'A', 
   41, 'B', 
   42, 'C'
)

SWITCH(
   WEEKNUM(CREATED_TIME()), 
   40, 'A', 
   41, 'B', 
   42, 'C'
)

Hi Kamille,

Thank you! That one helped me a lot. I try to do it with IF statements at first. I didn’t even know the SWITCH() function excisted. It kinda works now but I have a second problem… Is there a way to start counting the weeknumbers from sunday till sunday instead of monday till monday?

Let me know if you can help.

Thanks.

Yes. You pass either “Sunday” or “Monday” as the second argument in the WEEKNUM() function.

Thanks for the fast reply.

I think I already did it myself by adding: DATEADD({Created_time}, -1, ‘days’)

I really wonder what you thought would also work tho :slightly_smiling_face:

Gr.