-
Ideas on how to manage high volume, bundled update requests?
Hey Folks, I manage a later sheet where we will be rolling out regular Update Requests. These requests are grouped by Lead by Project. This means that when a request is triggered, some individuals may have 10+ project rows requesting an update. The issue: When these are triggered at the same time, they become bundled into…
-
Date and Time issue - Calendly>Zapier>Smartsheet
can'tHi I have people booking times with my company via calendly>zapier>smartsheet. However, the date and time arriving in the smartsheet cells is appearing as eg 2025-11-25T05:00:00.000000Z. I cant get this to change without it becoming UNPARSABLE. I have tried some standard formulas that AI is suggesting to no avail. Can…
-
From End Date Calculate Start Date
a date function that start with the "due" date(end date) and total hours to calculate the start date
-
MS Project vs Smartsheet connectivity
I have a project that is run in MS Project (Desktop) on clients SharePoint, which we also want to have in our Smartsheet account so that we can track the progress and allocated resources, without duplicating efforts on updating both. I have found this can be done via Data Shuttle (which supports desktop version of MS)…
-
Force refresh of page if User uses back button on Browser
I would like to find out how I can force a page refresh if a user press the back arro / button on their browser
-
Issue with WorkApp Attachments?
Is anyone else experiencing problems with users not being able to add attachments to sheets or reports in WorkApps? Users that gain edit access to sheets and reports to edit and attach documents stopped having that ability late yesterday.
-
Role and Permission Changes with the new USM
Hi There, I am looking for any description on Roles and Permission with the new USM. Are there any changes on the Roles and Permissions compared to the former license model? As an example I am especially looking for the User Management Roles (e.g. Group Admin, Resource viewer, Plan Asset Admin) as well as the Workspace…
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Best Practice Inquiry
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…