-
How to Calculate Week Number and total work done within a week
I am trying to calculate total work done within a week for a job and previous week as well.
-
Calendar App: What is the difference between "Ignore Weekends" "Hide Weekends" and "Show All"
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? Very confusing in the wizard.
-
Is Hide Weekends supposed to ONLY work with Monday as the week start date?
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 me.
-
Is there a way to create a dashboard that will update weekly?
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 way to set up graphs/tables that would update M-F weekly on their own? I don't want to pull from the last 7 days as that…
-
Why is my WEEKNUMBER returning two different weeks for the same day?
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/05/2025 and two are reporting to the wrong week. How do I fix this?
-
First day of week configurable in every representation
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 century ;-) So come on Smartsheet, start a new initiative to recognise the whole world ;-)
-
Calendarweeks in Gantt Chart
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 the Sunday of week 29, I would like it to show "week 26" or "cw 26" or just "26". Is that possible? Thanks Thomas
-
WEEKNUMBER function doesn't seem to be updating promptly?
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(TODAY()) = WEEKNUMBER([EXPECT FITTING DATE]@row)), 1, 0) I'm using the checkbox to filter a report so the user can see what…
-
Has the ability to state a type (start day) in WEEKNUMBER been removed
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 the function seems to be ignored. Has the ability to specify a week start date within the WEEKNUMBER function been removed…
-
Display the prior "Monday" date from the following week
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 the vendor on Monday to confirm the goods will be or have been shipped. I thought I would ask if this is possible before I…
