Help

Re: Comparing a Day of Week in a dropdown to TODAY(DAY())

997 0
cancel
Showing results for 
Search instead for 
Did you mean: 
118_GROUP
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, Having a lot of fun with the formulas.

I have a field “Day of Week” with options like “Monday”,“Tuesday”, etc.

I want to create a formula in a second field called field2.

Something like IF ({Day of Week"}=“Monday”,“1,”") OR IF ({Day of Week"}=“Tuesday”,“2,”")
etc… I cannot seem to find the best way to do that.

Any help/direction Appreciated.

Thank you!

3 Replies 3

This worked in my table (testing your example):

IF(DayOfTheWeek=“Monday”,1,
IF(DayOfTheWeek=“Tuesday”,2,
IF(DayOfTheWeek=“Wednesday”,3,
IF(DayOfTheWeek=“Thursday”,4,
IF(DayOfTheWeek=“Friday”,5,
IF(DayOfTheWeek=“Saturday”,6,
IF(DayOfTheWeek=“Sunday”,7,"")))))))

You may replace DayOfThe Week by {Day of Week}
Make sure you delete the " in {Day of Week"}

What is your use case? You already have a WEEKDAY function. Maybe we could advice in other ways.

118_GROUP
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks @Andre_Zijlstra , that IF statement worked!