-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
Automatically Change "Modified by" email item into a Name
Hello! My team is creating a form to collect, track, and act on paid-time-off requests and part of the system we're creating is making a form for folks to submit their requests through. We need to share parts of the content of this sheet with multiple different parties so plan to create some reports and dashboards to share…
-
Form Query String - Setting the date in the URL
I see that form URLs can take query strings to pre-populate the form, https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values In the examples, however, all of the pre-populated data is text, ie URL?field=text What is the format to pre-populate the calendar? URL?date=01/02/2021 is not working
-
Multiple Email address using SmartSheet form
Hello Friends, Is it possible to take multiple email address from user using SmartSheet form under same column (Type: Contact List) Example: I have a form with fieldname "Cc email address" where we need user to input multiple email address as cc email address. Accordingly I have setup a automation workflow to send email…
-
Linking form to email
I took over a smartsheet account and the form she built to help her manage the business. The form used to automatically email me and another employee with submission form entries (as well as populate information to a smartsheet). As of this week, we aren't getting the emails. I've tried to figure out where under forms…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
-
Can Forms time out?
Hello, all! If someone is filling out a Form, is there a point at which it can "time out," so to speak? If someone is working on a Form that might take 15-20 minutes to complete (looking up information to fill it out, etc.), at any point would it reset? I imagine this is not a problem given the nature of Forms, but I just…
-
Static Date/Time Stamp
I've looked around and I realize that this is a feature many people want within smartsheet. I was wondering if anyone has a workaround for this. I want to automate the start date to today but I don't want it to change so using =TODAY () won't work. The sheet that I'm trying to implement this in also uses a form to input…
-
Updating Fields Based on Input
I have a form in which I let people enter in either a Monthly Budget or Total Budget. If it's Monthly, each Monthly Budget field obviously gets filled in with a value, but if it's a Total Budget, those Monthly Budget Fields are left Blank. Q: I know how to allocate the Budget for each month, but is there anyway to populate…
-
How to create a weekly time card using smartsheet forms?
I want to create a weekly time card similar to sap format using smartsheet forms. I have attached the format for your reference.