Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
Hi Guys, Created a basic script to download all PDFs from a sheet. Use case: I use Document Builder to create documents from field inspections. However, we need to store these in sharepoint for redundancy. This script basically pulls all "PDFs" so you can then migrate them where you need to. I don't want to pay an…
I was trying to use the Scheduling: Create Workflow Schedule module in Bridge to set up a 60-minute timer that would alert our team if another workflow didn’t complete within that window. I was struggling with how to pass and access state values between the workflows. After working with a Pro Desk support agent, we figured…
Currently, the HR team manually pull a list of new starts, transfers and leavers for the on a Friday for the following week and send to a mailing list. We are hoping to automate this (as much as possible) in Smartsheet. Each different case type sits in an individual sheet (so leavers in 'Leavers' etc) currently, but I'm…
I am trying to calculate total work done within a week for a job and previous week as well.
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.
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.
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…
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?
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
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…
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…
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…
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…
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 ;-)
It looks like you're new here. Sign in to post and engage.