Skip to main content

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!

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.

Thanks @Andre_Zijlstra , that IF statement worked!

Reply


Terms & Conditions