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


#1

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!


#2

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"}


#3

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


#4

Thanks @Andre_Zijlstra , that IF statement worked!