In my testing: Show All: Ignore Weekends: Hide Weekends: One of these things is not like the others, and that makes sense. But Ignore and Show All seem to mean the same thing. Why have two settings? V…
In the Calendar App, Daily View, if I select "Hide Weekends", but have "Sunday" as the start of the week, Friday and Saturday are hidden, rather than Sunday and Saturday. This seems very very odd to m…
Right now I am sending out a weekly report, but am using excel and pivot tables. Some of the info on the report is YTD which is easy to set up, but other tables are only from the past week. Is there a…
I have a function that counts if a form was filled out at least once a week. They are supposed to have from Sunday 12:01 am to Saturday 11:59pm to finish the form. I have 5 submissions for Sunday 01/0…
Hi, for those in countries where the first weekday is NOT SUNDAY, being able to configure the first day of the week for all settings (including calendar picks etc.) to be another day would be very 21 …
Hi Everyone! Is there a way to show calendar weeks in the header of a Gantt Chart? I have set the timeline to "month" as a primary header and "week" as a secondary. But instead of showing "Jun 30" for…
Hi, I am using the following formula to populate a checkbox called "this week?" if a fitting is scheduled to take place this week: =IF(AND(YEAR(TODAY()) = YEAR([EXPECT FITTING DATE]@row), WEEKNUMBER(T…
I had this formula which generated a week number with the start date being Friday due to the type being '15' =IF(Date@row <> "", WEEKNUMBER(Date@row, 15), "") which used to work. Now the type within t…
A buyer asked that I create a sheet with a column to display the prior Monday "date" of a following week. The goal is to set an automation triggered by the date in the "Reminder Date" column, to call …
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in …