+6I have a column named Day name which is a single select field containing names of day - Monday, Tuesday, etc.
How can I create another column which gives the weekday number of this? I know I need to use Weekday() function, but how can I set it up such that it converts the string to work with Weekday() function?
Thanks.
Best answer by TheTimeSavingCo
Hi Mayank, I don’t think the weekday() function works for that as it expects a date
This formula should serve your needs, and you can modify the numbers as needed depending on when your week starts:
SWITCH(
Name,
'Sunday', 0,
'Monday', 1,
'Tuesday', 2,
'Wednesday', 3,
'Thursday', 4,
'Friday', 5,
'Saturday', 6
)
+31Hi Mayank, I don’t think the weekday() function works for that as it expects a date
This formula should serve your needs, and you can modify the numbers as needed depending on when your week starts:
SWITCH(
Name,
'Sunday', 0,
'Monday', 1,
'Tuesday', 2,
'Wednesday', 3,
'Thursday', 4,
'Friday', 5,
'Saturday', 6
)
+6Hi Mayank, I don’t think the weekday() function works for that as it expects a date
This formula should serve your needs, and you can modify the numbers as needed depending on when your week starts:
SWITCH(
Name,
'Sunday', 0,
'Monday', 1,
'Tuesday', 2,
'Wednesday', 3,
'Thursday', 4,
'Friday', 5,
'Saturday', 6
)
Thank you so much Adam!
Particularly thanks for taking the pain to write the entire function for me when you could’ve simply guided me :grinning_face_with_big_eyes:
Sincerely appreciate your effort. I will start using this.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.