-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
Default dates on web form
Hello All, I use smart sheet as project list and a web form as a work request. Our policy is that all request need to be submitted 4 weeks prior to their due date. Is there a way to have the duedate field on my webform defaut 4 weeks out from the date the form is accessed?
-
Web Forms - Set Schedule/Reminder
We recently decided to utilize Smartsheet for creating regular meeting agendas and created a web form that could be sent out internally to give employees the opportunity to submit their input/items for the agenda. I wonder if there's a setting or plan for the future to have web forms be automatically sent out to users on a…
-
Full Screen Published Sheets
Hello, Would be useful for the sheets to be have the ability to function in full screen mode only as default, as a better view when embedded in another site. Is this already possible, if not could this be adopted as a function? Cheers,
-
Web Forms
I currently have a web form that a user submits when they require time off. I am using a contact list for the name field. When a form is submitted I email the manager. Once she get it she either approves or not. If she approves I want an email to be automatically sent to the user. This is working but I'm afraid if the name…
-
Refresh automatically expands collapsed rows
Has anyone noticed a recent change that automatically expands collapsed rows when a sheet is refreshed? Thanks, Joe
-
How to show the actual person who added information to a sheet
In smartsheet, you have the Created By and Modified By autonumber system properties. If you have created a web form, any responses provided via the web form reflect "web-form@smartsheet.com" in those columns. Is it possible to get the actual persons email who submitted the information via the web form reflected there…
-
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
-
Web Form - Can you add the discussion column as a direct field.
Hi All, When creating web forms is it possible to add the disscussion column directly onto the form rather than creating a seperate "comment" column for potential user responses. Reasons being, even with min 3 lines of text allowed in the comment box, its can still make a master sheet look messy and confusing with merged…
-
Alert notifications when web form submitted?
Is there any way to send alert notifications ONLY when a web form is submitted? I am in a scenario where I've set myself up to be alerted right away when Anything changes, but I have two co-workers who also need to be alerted right away when a web form is submitted. Would love to have this be an actual setting as opposed…