-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
-
Move a row form one sheet to another in a different workspace
Hi I am trying to move a row from one sheet to another in a different workspace. I am the owner of the original sheet and I am the owner of the destination sheet and workspace. Is this possible as nothing comes up when o search for the sheet I want to move to.
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Document the value of function / calculated field every day
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working sheet 1). These values are used for dashboards and so on. I wish to automatically…
-
Can I access/download spreadsheets I previously made without paying for the upgrade?
I no longer have the need to use the Smartsheet service but I would like to e able to refer back to the reports, sheets, etc. that I made while using the upgraded version. Is that not possible?
-
Sheet permissions
When I share a sheet with anyone from my account with editing permissions, they can edit the sheet on the mobile app but not from a computer. Yes, they also have a Pro account and it also shows the proper permissions on the "share" page. I have used Smartsheet at my last job extensively and know the software quite well but…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
Move rows to another sheet Workflow - Select a destination sheet is blank
I have created plenty of sheets that have a workflow to move rows to another sheet. There were no issues to create those automations before until now. I am the owner of all of our Workspaces and sheets but for some reason Select a destination sheet window is blank. I have tried to sign out and in and tested with the…
