-
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…
-
An improvement is needed for a Delete/ Undelete paradox.
Anyone with access to deleting a project, should be able to undelete that project without changing the ownership of that project. If I accidentally delete another person's project file, and I am tagged as the person who deleted the project file, I must then contact the owner of that project to undelete it, even though I…
-
Can not move my sheets/reports between folders
Im trying to create new monthly duplicate folder with all shared links we are using for our data project , for some reason i can not move sheets and reports between folders , only to workspace that not commonly used by us Anyone is facing the same , your support is appreciated Thanks in advace
-
Merge Cells
Is it possible to merge and split cells?