-
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…
