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