-
Is it possible to over ride a formula when using Column Formulas
I have a sheet where new rows are automatically added to the bottom of the sheet from a form. I want the newly added rows to have formulas added to them, which I can accomplish using the Column Formula feature. However, I want to be able to over ride the formula in some cells. Specifically, a new row is added from the form…
-
Merged: Dynamic / Cascading Dropdowns
This discussion has been merged.
-
Merged: Smartsheet forms, logic for date dropdowns
This discussion has been merged.
-
[FORMS] URL Query string not working
Any idea what could cause it not to work? When I add the query ?Property=ABC it just refreshes with only the URL. It is just working on this one form but not on the others. What do I need to check? I've already read the documentation. Re creating another form on this sheet does not help. Here is the link, but please DO NOT…
-
Form Logic to link to another existing form
Hi All, I have recently been introduced to Smartsheet and am trying to streamline some processes. Is there functionality to add logic to a from to directly open another form based on a selection? Example if someone selects the form is related to department A, it will take them to fill out an existing form that department A…
-
Breaking up a long form
Hi all! Ran into some snag with forms... I have 40 items in 4 categories to rate. Putting all 40 items on a single form is not the ideal user experience (but if nothing else works, that's how the cookie will crumble). So, I thought I would break the forms into four forms. One calling the other after each submission. I can…
-
Problem retaining formulas in cells that are in a form
I have an intake log that has a form for parents of child patients to complete in order to apply for services. I have added logic that allows the user to complete the patient's address. Then, I ask the question of "Is your address the same as the patient's" (Yes/No). If yes, I want the parent's address fields to populate…
-
How to retrievie Submission forms?
We have a customer request form that customers can fill in for works requests. How do you retrieve the completed submission forms to print to place on hard copy records
-
How do I find the Source Sheet for a Form?
I have the url for the form, but need to locate the source sheet.
-
Separating data into separate rows, under the original an auto generated column number
My department has an existing SmartSheet, to track travel. This sheet autogenerates a number based off of a form submitted for approval. The issue is that in the form staff are able to list ALL travelers for the trip, which results in the names being included in one cell. However, I need to be able to have each traveler in…