Weekday formula not corresponding with timeline

Platform discussions
,
1

Hi,

I’m trying to put in 2 formulas that correspond to a timeline.
The timeline is how long an event runs for, and the formulas are to automatically show which day of the week they start and end.
The formula I’m using for the start day is:
SWITCH(WEEKDAY({Timeline#start}), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”)

This works fine.

The formula for the end day is:
SWITCH(WEEKDAY({Timeline#end}), 1, “Sunday”, 2, “Monday”, 3, “Tuesday”, 4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”)

According to everything I’ve seen (and checked with the AI assistant) this is the correct formula, but it’s not working. It’s showing the start days of the timeline, not the end days. So I’m not really sure where to go from there.

Any suggestions?

Thanks!

2

Hi
Both formulae work when I tried them. I have noticed that just typing out a column name does not work sometimes. Have you tried deleting the column name from the formula and inserting is using the column from the formula builder?

image