-
Synching multiple items per day to Google Calendar
Hello, My company tracks vacation/personal days using Smartsheet. We export to Google Calendars which is what we use for most event/meeting planning. The problem I'm having is that when more than three people take the same day off, only three of the people show up on the Google Calendar. Its only happened a few times but…
-
Webforms for help requests - best practices
We have a webform created that our customers can fill out to submit help requests. What is the best way to disseminate this webform and make it available for them to fill out? I don't want to have to email it to them, but at the moment I don't have a space on a webpage to embed the link/form. Would that be the best way to…
-
Web Form
Hi there, I was wondering if there is a particular access level where someone can see and/or edit a web form without having access to the data behind the scenes? I'm asking because the person isn't computer savvy and gets overwhelmed easily but would like to be able to edit the webform since it will be used by her to fill…
-
exposing a report in the email body
First time posting here so apologies if this has been answered. I've searched through the posts and wasn't able to find an answer. I'm trying to move over to Smartsheets from Google Spreadsheets for a few reasons but mainly for the automated reporting. The one thing I noticed is that I can only send a report out as an…
-
Form and Sheet Functionality - Available security levels for users
Hi, We've created a web form in Smartsheet that users populate and then directly feeds a "master" sheet. From there, we are creating multiple reports off of this sheet for our various departments. Our issue is how to restrict user access to the sheet as we don't want data to accidently be deleted by one of the many users.…
-
Google add-in: "Combine into one file" changes the orientation of the document
Hi there, Help! I'm using the SmartSheet add-in to print onto custom envelopes via Google Docs. I've laid out the merge fields so they print in the right spot of my envelope. The doc in Google is Landscape. When I create individual PDFs or Google Docs, they appear as landscape too. However, when I "Combine into one PDF",…
-
Sending a web form to all the people listed in the contact column
I have several programs, and they have different contacts. I don't want to just add them all to my contacts and send the web form individually. Instead, when I create a sheet and want to send the web form, I'd like smartsheet to use all the emails I have listed in the Contact column. Is there a way I can send the form to…
-
using secure sheet link
I havea brand new work sheet. Would like to use secure sheet link. It's not clear if I must send the old shared invite first and then send a second email with the secure link or if I can send the secure sheet link from the get go? What's the difference in the link they get in the original share invite and the secure link?…
-
Setting date ranges with start-date to start-date and end-date to end-date dependencies
I have a project where I am setting a range of production dates and want the sheet to auto-update if I update that there is slippage in the timeline to see how far out things push. It is easy to schedule dependencies on the front end. For example - if I have items: 1. PO to readiness of raw materials is 2 weeks from the PO…
-
User form- input with dependents?
Hello, I have a project template that I would ilke to use to put a project on a master schedule. I would like to fill in this template with a form, while it adds the item to a master schedule. Can I create a form that has rows with children dependents? Thanks, Harrison
