Hi there, I am trying to determine if a person is on duty or off duty on a day
I have:
7 Boolean switches for Sun thru Sat
An excel formula determining which day of the week it is.
An ONDUTY column that should show ON/OFF depending on whether the boolean switches are switched on or off for that day of the week.
Does anyone have any ideas?
First, move your “day of week” column to Glide. Use a math column with WEEKDAY(N), N being the “Now” value.
You’ll receive a number that corresponds with the current day. Proceed to use an if-then-else column.
If weekday equals 1 then return the value in the Sunday column, 2 then return the Monday column and so on.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.