-
Pulling in selected data from another sheet when conditions are met & then marking that as used
I have a complicated use case I could use some help with. Apologies if I'm using the wrong words here; happy to provide clarification. Here's what I'd like to happen: User submits a form to request a voucher for a specific exam. Row in SmartSheet 1 is populated with user's data. Upon row population, another sheet…
-
10 digit fixed numeric field
Hi, I have few fields where I want to add a validation/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric/text etc...they don't help what I need. Also, Can we trigger any flash alert for…
-
Merged: update forms
This discussion has been merged.
-
Offline form 'Created Date' column discrepancy with actual submission date
Hi all, I've been supporting a project that's utilizing Smartsheet's offline form submission. We want to capture the date of each form submission. However, since this is a large and fast-paced project, and we're doing A LOT of data collection, I tried to minimize the friction a person experiences while collecting data. So…
-
Create an Evaluation Tool
Hi Friends, I am new to smartsheet, please be aware of that, likely some of my struggles are obsolete but I just have no idea. Problem Statement: On global business level, we created a form for employees to forward improvement Ideas to a specific team that will execute them (or not). The form entries are logged in a…
-
Merged: Validation Phone Prefix is missing for many countries
This discussion has been merged.
-
Logic in Forms RE: Max/Min Date Conditions
I am trying to build a form that is for tuition reimbursement applications. By policy- applications cannot be received either 30 days before OR after the semester start date. I have a pop up message built into the logic to appear if one of those conditions are met. However, I can get only ONE to work, but not both built…
-
Way to get average number of submissions per day?
Working on an intake form with hundreds of responses and I wanted to know if there was a formula to calculate the average amount of responses per day. Thanks!
-
Are there plans to allow the API to create forms?
I was wondering if you plan to include the forms object in the API anytime in the future? I have a need to create sheets and forms at the same time. Thanks, David
-
Automatically delete blank rows when using a Form to add to the bottom of a Sheet
I'm submitting this enhancement request, but this should really be viewed as a glitch or break-fix. It makes no sense why blank rows would appear when submitting via a Form. This is a core function of Sheets and should be more streamlined. Manually deleting rows is incredibly inefficient and has already lead to multiple…