-
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…
-
Report on tasks for the next 3 weeks
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 the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…
