-
How to copy questions when designing a form
Dear All, Do you know an option how to copy questions when designing Smartsheet form? I need to use several sets of the same questions with some minor changes and it would be great to just copy them than designing them from the scratch ... If such option exists and you know it, please let me know. Thank you!
-
Managing fields displayed in an automated update email - placeholders?
I need to create an automated update message that will be sent to executive leadership. The message contains three columns from eight rows on my project sheet and has a link embedded to the published sheet. (See below) I need to remove the link automatically inserted at the top of the message. I tried placeholders (which I…
-
Formula to check 2 columns and give a total
Hi, Im looking to create a dashboard that tracks MI tasks, but within 1 sheet it will contain multiple proejcts. To combat this, i have created a "header" field, this marks the title of each project. Each project also has a status Is there a formula i can write that checks if header is ticked, then count status as 1 if "in…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
Character limit to Email message within the Form Settings
Is there a character limit to Email message within the "Form Settings"? It looks like there is, I've tried entering the information and was not able to enter at certain point. Can someone please confirm? Thank you!
-
Re-open Partially Completed Form
Hi all, We have a sheet that collects information about our accounts. Our contracts team enters some of the data via a form when they hand it off to our accountants. However, they don't always have all the information at the same time, and some would prefer to enter it piecemeal rather than needing to dig it all back out…
-
How to share a form after it is filled partially?
The form first needs to be filled partially and then shared to others to complete the rest of the form using the information previously submitted. The previous information filled shouldn't be made editable to the next user of the form. Is that possible? In the attachment, I want first four fields to be filled by me and the…
-
The default value set up in the form creation not working consistently
The default value set up in the form creation does not always populate cell when new rows added. Multiple grid columns in a single record have dropdown list columns using "N/A" as default value set up in the form creation, unless of course another value is selected. When the new row adds, some columns have blank cells…
-
European Date Format - Only working visually?
Hi, I have two columns in my sheet that are set as dates, though many of them are formulas that derive in dates based on variables such as, [If date 1 = X and task 1 takes 3 days, DATE = Date 1 + task duration = X+3] and so on. I have the date columns formatted in Day/Month/Year: however it only seems to impact the…
-
Notify form submitter that their request has been declined
Hi, How do you automatically notify the person who has submitted the form if their request has been approved or declined?