-
Bring data from source sheet in to separate columns in data sheet
I have a source sheet with >250 rows with each row having a unique [Criteria]. We assign [Status] and [Approval] status to each row that changes in a regular basis. Demo of source sheet: Given the number of rows, I would like to improve visibility of the changing status's in new sheet that will bring in the [Criteria] and…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
how long after you pay for 12 users will it be before you can add the users in?
The system just keeps saying "there was a problem."
-
Help button not working
Have any of you had a problem with the help button not working? This is the little round button that has a question mark in it. I have tried restarting and refreshing but still nothing happens. I am not getting an error message, it just isn't working.
-
Sum of values in a column within quarters
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
-
Smartsheet formula saving error
I have been using a formula in smartsheet column however from last week i have tried to update the formula and when i save the sheet the following happens please help as soon as possible
-
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
-
Health Indicator Claculation
I Am using the below formular in my Health Indicator but even though my project is on track My overall project indicator is showing Red. What have I done wrong any assistance please :-) =IF(AND([End Date]@row < TODAY(), [% Complete]@row < 1), "Red", IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY(1), (TODAY(1)…
-
Return update request URL via Smartsheet API
Update requests can only be accessed via recipients' email. In this community discussion, several use-cases are described in which it would be useful for admins or developers to be able to access the URLs associated with update requests. In my organization, it would be extremely valuable to be able to access update request…