-
Getting errors trying to transfer ownership of a sheet
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
-
User Subscription Model: Non Admin access to Users Seat Type
Hello, I am a System Admin and want to provide assistance for Workspace Admins at my company with regards to User Seat Types. From this help article: https://help.smartsheet.com/articles/520104-share-sheets-reports it mentions this: "Ensure that collaborators you’re sharing your sheet or report with have the right account…
-
Allow Redlining & Highlighting within cells
Currently, you can do redlines etc but it always effects the entire field. Which is really quite annoying as in project work you sometimes wish to strip out part of a requirement while keeping it tracked. If we could allow more specific editing within a cell that would be ideal. You can work around this. But it will hurt…
-
Using INDEX/MATCH for a Master Sheet
Hi all, One way we use Smartsheet is to record real-time data that is then stored and referenced. I work at an aquarium so, for example, we will take daily measurements across multiple systems for things like temperature, salinity, pH, and on and on. The same parameters are tracked for all of our systems, but the thing is,…
-
Restoring from Sheet Snapshot when auto-generated numbers are involved
I recently inadvertently deleted a large amount of data from a sheet that has an auto-generated number column. While I know how to restore from a backup, I have no idea how to restore the originally assigned auto-generated numbers without completely messing up the sheet. Has anyone come up with a creative solution to…
-
Formula not Calculating the Correct Number
Hello, I have a formula that counts notifications that are tracked on another smartsheet each month. The formula is: =COUNTIFS({Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row , {Impacted Department}, <>"XX") The results from this formula are no longer calculating correctly. For…
-
Requesting Status
I am an owner and an admin. Why can i not request status?
-
Creating a summary for a workspace
I have a workspace that has a revolving set of sheets. Some of the sheets are active for the time being but are not active now. There are several cells that I would like to have on the summary , like the client name, the status of the sheet, the date expected to go live, health of the sheet. What would be the best tool to…
-
Need to retrieve the complete driver payroll sheet
I am unable to retrieve the complete driver list and would like assistance in recovering last Friday’s data
-
Automation to Combine Multiple Row Attachments into a Single PDF
I’d love to see a feature or automation added to Smartsheet that allows users to automatically combine multiple PDF attachments into a single PDF. Use Case: I have a Smartsheet where we collect applications, and each application includes several supporting documents uploaded as individual row-level PDF attachments. When…