Mar 26, 2018 05:03 PM
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!
Mar 26, 2018 11:46 PM
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"}
Mar 27, 2018 11:51 AM
What is your use case? You already have a WEEKDAY
function. Maybe we could advice in other ways.
Mar 27, 2018 12:42 PM
Thanks @Andre_Zijlstra , that IF statement worked!