-
Merged: Column Formulas in a Form
This discussion has been merged.
-
Merged: Dynamic drop down lists on Forms/Sheets
This discussion has been merged.
-
Merged: URL Shortener for Long SmartSheet Links, w/ Custom URLs
This discussion has been merged.
-
Merged: Feature Request – Enable Copy and Paste for Header Columns
This discussion has been merged.
-
Form entry: Create new row for each checked checkbox in form
I have a form that uses checkboxes to accept user input. I want the form to create a new row for each checked item in the form. I do not want to rely on a third-party solution for this, as I am not part of the team that makes that type of budgetary decision, and it will unquestionably be denied. (Category "Formulas and…
-
Restrict dropdown options as an option for forms
There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns. Use cases for our team in particular would be project type and add-ons. We have different customers using different forms on the…
-
Best Practices of archiving sheets
Hello, I currently use a form to populate a sheet for any new sales leads. We're at the end of our fiscal year and I'm trying to archive all old leads and start a new sheet. I want to know about some best practices of achieving this. I was thinking about the following ways: Move all open leads via automation to a new sheet…
-
ENCODEURL Smartsheet Function
We have several use cases where we build custom URLs that include column data from a source sheet into a Smartsheet form URL string on a target sheet that hosts the form. It would be very helpful if Smartsheet had a function like ENCODEURL. Currently we have to build an ugly formula with multiple embedded SUBSTITUTE…
-
Has anyone tried to create a trivia game using Smartsheet?
Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other people wrote. I thought about using DynamicView to allow only view access by user, but I'm wondering if I can be more…
-
Data Shuttle: Will workflow run if file is attached via form?
Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form connected to the tracker. The tracker will then use Data Shuttle to pull over the quantity, description, and item number of each…