-
Is there a way to auto-populate a field on a form to match the same field on another form?
I'm trying to create a 3-step, or 3-page, Production Order for commercial production. One page would be for client info, one for script details, and one for editing details for each commercial. I have it set to automatically take the user to the next step once they hit submit. So each step (Parent Row, script, each edit)…
-
Google Calendar
Hi everyone, I am trying to sync my smart sheet with my google calendar, but it appears that only the "Task Name" column comes over. Do you know of anyway to get a column to sync with the Address or Description fields in calendar events? Thanks!
-
Form Reminder
Is there a way to set up a daily reminder via a web form without having to share a sheet with the individuals who will be completing the web form? Scenario: I have a report that needs to be ran daily by a dept. outside of my office. The report should be ran each morning for the data from the day prior. I created a web form…
-
Calculate the Xth Weekday of Any Month
I am new user to Smartsheet and I am trying to figure out a formula that will calculate a date for a question like "What date is the 3rd Monday of a given Month". Through some google searching I came across this answer for a straight excel formula:…
-
CELL LINKING
I AM USING SMARTSHEET TO HANDLE MY BUSINESS, ie: TRAVEL AGENCY. I WANT A WAY BY WHICH ALL MY DRIVERS CAN UPLOAD ABOUT THEIR AVAILABILITY AND THEN ALL THESE THINGS COME DIRECTLY TO MY SHEET. AND THE DRIVERS SHOULDNT BE ALLOWED TO VIEW MY SHEET, FOR THAT I THOUGHT OF CREATING A SEPERATE SHEET FOR EACH AND EVERY DRIVER AND…
-
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
-
Here we go!! Ready to roll out our BETA project plan!
After a couple of weeks learning Smartsheets and simplifying our project plan, we are ready to beta test our PM Lite template. https://app.smartsheet.com/b/publish?EQBCT=f5644ec0fe854b2b9c3bf74084bf86d7 It's still pretty rough but with a group not use to a formal PM process it should get us started on the right track.…
-
File links uploaded into Google form are garbled in Smartsheet
I have an existing Google form and one of the options is to attach files. When the form is submitted, the values I'm getting in Smartsheet are garbled, something like: "0B6fDccPdKcYeY0tlcjJnVTlMYWM,0B6fDccPdKcYeQi1Malg1YXVDMmM,0B6fDccPdKcYeZkIxVURBU3hjbWc" This column is supposed to be populated with Google Drive links.…
-
Split-screen View to compare sheets
In other programs there is a split-screen view or arrange windows in order to compare two documents. Other than opening two different Smartsheet windows (and, subsequently, opening a different sheet in each window), is there a way to compare sheets? I have two versions of a sheet (where I am using data from one to update…
-
Send Row Default Fields
Greetings, Will there ever be an option to save the "Send" (by row) "Include" options to be reused. I found a work-around to create a report with only the pertinent fields, but this is unwieldy. Example: When I have a support ticket to answer, I do not want all of the fields to display in the email and going through and…
