-
Ideas on how to effectively create a new sheet that collects information to update status on another
I am struggling to find other answers on the community for this situation. We are creating a log of all equipment. I am creating a second sheet for when that equipment is removed. When someone submits through a form that equipment is removed, I would like the second sheet to automatically update the status on the original…
-
How to Show Serial Numbers Per User in Dynamic View (e.g., 1, 2, 3 for Their Assigned Rows)?
Hi Smartsheet Community I'm working on a project where I’m using Smartsheet Dynamic View to let users see only the rows assigned to them. My setup uses: In the Dynamic View, I want each user to see a Serial Number (S.No) column that starts from 1 and counts upward based only on their visible records. Example: Let's say the…
-
Merged: Description section for sheets and reports
This discussion has been merged.
-
Are New Folders No Longer Allowed In Sheets Directory
Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create a folder in a workspace, I cannot drag-and-drop it into my Sheets directory. Right-clicking "Sheets" in the Browse panel no…
-
Can I link a cell to a folder on my hard drive?
-
Record the user who last attached a file to a sheet
Good morning! I'm trying to make a work-flow for 1 sheet that has 2 users. I am the sheet owner and I've created a data shuttle that updates all of the rows on the sheet every time one of us attaches a file to it. When we attach a file - it updates a to do list for the week. Whomever is attaching the file is working…
-
forms and empty sheet rows except for the ID (Locked primary column)
We have a form to support entry of data for requests. Occasionally I have found several empty rows except for the ID field in our sheet, and I would like to understand why that happens so I can educate my team.
-
Moving rows from one sheet to another where both have different auto numbering conventions?
Hello, My organization is using Smartsheet to keep track of contract requests as they are submitted and reviewed. I use a sheet which auto numbers each row with a contract request number (prefix CRF-###). Once the request is approved, I want to have an automated workflow move the row to our active contract tracker and…
-
Sheet Statistics
Something that quickly shows # of rows # of columns # of cells # of cross references # of unique formulas I'm sure there are other metrics that would be nice to see quickly Close to breaking warning or notification to sheet owner Could be part of Work Insights but all together, like a table, and update immediately.
-
Record date and person who last attached a file to a sheet
I love data shuttle - and have built so many of them into my systems, both automated data shuttles and integrating data on attachment. We are a team of 2 people managing a common database, we have divided our tasks up into weekly and monthly tasks. We swap who is responsible for these tasks on a monthly basis to shake…