-
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…
-
Notification when new State is added to list - unique list
Hi, I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past. The client's State is automatically added to the sheet from a workflow, and I need to get notified when ever we have a new State added to the list. I think one way to do is this is to create a new…
-
Reminder Notifications: translate from templates to new sheets?
Loving Smartsheet so far, and excited about finally having a truly custom system together for tracking project status for our clients, based on our unique parameters and not something superimposed! I've created a template that is working well, but would love to see reminder notifications translate from the template to…
-
Design Error for Resources Allocation - Percentage vs hours/days/weeks
Edit - I may have been a bit harsh calling this a design error, I do see cases it would be easier choosing percentages for resource allocation instead of hours/days/weeks - but making the latter an option would be an amazing improvement. The current design seems relevant for a projectized organization with dependables and…
