-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Time Duration Calculation
I've seen a few ideas on similar topic threads but none of them worked quite right, so I'm trying again! I have a form staff fill out to record their overtime and the reason for it. Does anyone have any formulas that I can use to populate a column showing the numbers of hours:minutes of overtime based on the "Scheduled Out…
-
How do I create a summary page or report from a Financial Donor List?
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and the total amount they have donated. Also, is there a way for a new donor to…
-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
Are there Smartsheet Developers for Contract? If so, where?
Hi, My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked with creating a project management system to handle the sudden influx of projects due to…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
How can I automate a subtraction
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks in advance.
-
Access Security for Forms
Does anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two options. * Anyone * Anyone with a Smartsheet login I use Smartsheet forms to submit project tasks (not too confidential) and…
