-
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?
-
Date value is off of Modified Date is off by 1
Something has changed. I have a formula =[Modified Date]@row that captures the last modified date and keeps it static. I do this as I have rows backed up nightly to another sheet if they were modified. Just using Modified Date doesn't work as the date changes once it's on the new sheet. It's now rounding the date up. The…
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Zoom in and out
Is there a way to zoom in and out on a sheet?
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…