-
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.
-
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…
-
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…
-
Transferring Multiple Files
First, the company I work for uses Smartsheet Gov, and second, everything is within ONE (1) workspace (I am horrified at that!), but that happened long before I was hired. Anyways, I have a FOLDER, that I would like to transfer ownership of all sheets and reports, and templates from myself to another user on my team. Now I…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…