-
Publishing vs. Sharing Forms -> Reports -> Dashboards
Hi! I have a sheet the collects information through a form. So, a user submits a request through the form, it gets recorded in the sheet. One sheet holds all user requests. I have a report created that filters the rows based on the current user (and the email in the original form). This report is then displayed in a…
-
Using field from sheet to pull data into a form
Hello. Is there a way to use a field that is defined on a sheet to pull associated data into a form? For example, if I have a request ID for help desk tickets. I want to use a form to query or pull in the data from a specific Help Desk request ID, allowing a user to see what is in the record. Then, I'd like them to be able…
-
Return Column Names AND values from row in a reference column
I'm trying to figure out how to return the columns and values found in them for any given row. I have approximately 200 unique columns that are populated from a web form if/when the column is relevant. individual rows track construction items completed. Each row identifies crew, date, job number, etc., and the remaining…
-
Dynamic Forms
Hello I have my project plan with certain people assigned to tasks. Each week i would like to have everyone fill out the percentage they are complete on the tasks that are associated with the week via form. I was wondering if in the forms i could have the user select their name from a drop down then see all the tasks they…
-
Forms with formulas
I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to…
-
Created form is it possible to display autonumber
Hi, I have a form to created that collects data where in order to avoid storing personal information I have set up a column assigning autonumbers to every case. Now the process is that the from is filled in by one team, the second team receives a notification to update. So we need to make sure the Auto number/ case number…
-
Vaccination Status/Testing Report
Does anyone have an easy solution to tracking employee weekly testing? My thought is that any employee that shows as unvaccinated will receive an alert each week to upload their test results. (I don't have a problem setting that up). From there, if an employee doesn't upload the test results each week then an alert will be…
-
Can you have hidden fields on a form become visible depending on value in another field?
So on the user end of the form, I have, for example, a Yes/No question about a meal. Question: Will you be attending the luncheon If answer is Yes, then additional fields will appear asking about meal choices, accommodations, etc. If the computer says No, then the fields regarding the luncheon will stay hidden. Is this…
-
URL String Form Erroring on Submission
Hi I have set up a URL string to grab some data from one Smartsheet that the form is generated from that is used to effectively tie together two Smartsheets with a common key and enable data from one sheet to be bought across to the other using index matches within the 2nd sheet based on this common key. The issue I have…
-
Scoring Formulas
I'm looking to convert a process to smartsheet, but am trying to determine if there is a formula to make the concept work. Currently I have a form which asks a series of questions - each question has a single select option of "yes (description)" "no (description)" and "n/a". For each question, there is a score associated…
