The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I am trying to convert between WEEKDAY(TODAY() and the word version for the day of the week. I would imagine it is a common need.
This works just fine.
IF(WEEKDAY(TODAY())=1,“Monday”, “”)
Why might this not work?
IF(WEEKDAY(TODAY()) = 1,”Monday”,
IF(...
I was trying to make a form that was sort of an order form and my formula field with the total cost of the items wasn’t on my form. I had no way to add it.
I tried on a form for another table that was similar and it didn’t work there either.
Is this ...
Got it! Thanks so much! Here is the final working formula in case someone needs it. I actually had to go in and pick the functions out of the list. For some reason copy and paste isn’t great for making functions.
IF(WEEKDAY(TODAY())=1,“Monday”, IF(WE...