I’ve seen this addressed in older posts but, I think that was before Glide added the new computed columns…
In my google sheet, I used an Excel formula of
to format the date in cell D2 to the weekday (Monday). However, as I add rows, I have to copy the formula down into the new rows.
I prefer to build this as a glide computed hyperformula column but, I’m getting unexpected results. I have used the same excel formula =TEXT(A1,“dddd”) and indicated A1 to be my Start Date column. The result is that some fields are blank and others have four digit numbers that don’t seem to relate to the days of the week.
I appreciate any ideas you may have.