Discussion List
Data Shuttle Upload: To use one-drive shared file as a Source Sheet
Hi all, I am using data shuttle, to upload the data from Excel into the Smartsheet sheet, and within the Upload workflow I am not able to find the find the shared folders where the source file is existing. In order to upload the shared file should I create my own folder and dump the source sheet into that? FYI: I am able…
Ability to remove "Submit" button on Forms
Having the ability to remove the "Submit" button on Smartsheet Forms would be helpful in cases where users need to go to a form to submit a request, but where we have exceptions to the rule. If they answer "Yes" to a specific question at the top of the form, then we show a dependency child question that says "Please reach…
Linking new entries to previous entries - tracking attendance
I'm trying to create an easier/faster way to track attendance at the multi-week classes that our health educators teach. Currently, they have to enter in static information every time they complete our outreach tool (like, address, timing etc) and I am trying to make it so that they only have to enter that information one…
Workflow Delivery Alert
Hi! We have a new person on our team, and she's a sheet admin to our main program sheet, but she's not receiving the Workflow Delivery Alert messages. Do you have to be a System Admin to ensure she receives those? Or is there a way to do it and I'm just missing it?
Starting from scratch.
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
Changing / Moving Existing Profile Data - Intake Sheet to Project Sheet
Hi!! We have a large program & want to change where some of our Profile Data fields are being entered without breaking things / renaming fields / doing a ton of avoidable repairs. I'd love some advice on common issues / the best approach! ------- Program Setup (for reference if needed, feel free to skip to the goal 😊) Our…
Using column formula when the formula in row 1 is different to the other rows...
Hey guys, I'd be glad of some help.... I'm trying to create a column formula which uses a piece of data from the row above, which it doesn't seem to like, as it appears that the formula must be created in row 1 for it to work? I want to use column formula as I'm adding to the sheet via a form and want the column to auto…
Weird issue - COUNTIF Date Cross-sheet Reference
Hi - I'm doing a very simple cross-sheet reference for a count of dates and it's not working. Sheet 1: Date column has a series of serial dates. Column14 has a formula that is not working. Sheet 2: This has a Date Completed column. The formula in Sheet 1 in Column 14 is: =COUNTIF(Date:Date, {BPD-DateCompleted}) - ...where…