-
Drop Down in Forms
i would like to know if its Possible to have the Same Drop Down in 3 different Forms that get filled out. but the Kick is i would like only to Show some of the Items in the Drop down in each Form. but i am looking to keep it to only 1 Drop down for the Main page that holds the information. and i its going to be a long…
-
How do I set a form logic to exclude weekend?
How do I set a form logic to exclude weekend in such a way that when the Date Created falls on a Friday and the Date Required is on Monday (next week) that it will show a hidden text field (to justify the urgency)?
-
Can input from one form separate to two rows when they input to sheets based on conditions?
We currently ask people to select one form per one need for referral into a program. For example, I want to submit a referral to a community health team and another one to behavioral health team. I need to submit two separate forms because each form submission will create one row to master task list where it then auto move…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
👋 Hi everyone, I’m happy to be here!
🏥 Where I work & role I’m a Grant & Development Coordinator at a community-based organization that is also a certified culturally specific behavioral health provider. Our work blends behavioral health, community health services, public health programming, and a cancer support center. 📊 Background & Smartsheet experience I…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
Some clarification to clarify
I have a few questions that I need clarification on: This is a question about multiple selection able to run report and auto counted and group in report I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in…
-
Changes over Time - COUNTIFS?
I have a project where a group of users can submit a smartsheet form at any time to request a new enhancement to one or more of 3 tools. One of these tools is managed by an outside vendor and therefore management wants to be able to track number of enhancements submitted to them as well as how they progress through status…
-
Automatically HyperLink URL that's pasted into a form
Hi Smartsheet community. I am trying to figure out how to directly link a URL (pasted into a form !!) to a cell with the exact same hyperlink click-word for that link type. Let me explain the situation better: My company has a sort-of project database spreadsheet to keep track of "leads" or projects that could progress…
-
regex validation
Please add support for validation in forms using regular expressions aka regex. There are currently a few canned validations, but regex support would allow us to validate pretty much anything.