Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for January 2017
Discussion List
Automatically move item to different Smartsheet once completed?
I have a feeling that this solution doesn't exist within the current setup. Is it possible to move a row from one Smartsheet to another once the item is shown as completed? Thank you!
Requiring comments based on Web Forms Answers
Was trying to use web forms for a basis of a survey. Ideally I would like to create a required comment field based on the answer of the drop down box. Is this possible?
Multiple Order Tracker
What's the best template to track multiple orders from multiple people. We've tried uploading PDFs to rows but can't capture totals of each product. Drop down menus could work, but no way to add in quantities. Please help!
Resource Allocation
I would like to create a Team in Smartsheet that is identified as a Resource. Is it possible to create a Resource without assigning an email to the resource?
Percent Complete - by date
Apologies if this is a repeat question, or not one of my brighter moments, but I'm looking for a way to display incremental milestone/project progress - at a glance - and by comparison to other points in time. Everything I've found shows progress as of today (where we are now) but I want to be able to see where we were…
Change drop down cell to Complete if %=1, If not leave drop down cell at currnet value.
We have Project State pulldown column that consist of Active Complete Future Parked. We also have a %Complete Column. Is there a way to set the Project State to Complete when the % = 1(100%) and leave it at the current value if the % <> 1? If there is a better method or sheet setup I am all ears. Thanks!
Sorting
I would like to sort rows by Status column. Currently I have to click on the dropdown below the column heading , click on sort then click on the way I want to sort. In Excel I can sort by clicking on a column heading if I set it up that way. Is there a way to sort automatically when the status changes, or click on a column…
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
Removing Months Headline from Calendar View
Hi, I am trying to print calendars from my sheets without the month headline on the top. I find it to be very confusing as it will not only list the month I am printing, but instead lists the range of months for the first date on the calendar to the last. For example, if I want to print February, it will say at the top,…
Backup - Link attachements to row ID/number
Hi, When you make a backup of a sheet with many attachments such as pictures and pdfs these will all be downloaded to one big ZIP folder. Say you have 500 rows with attachments, there is no way to link the attachment to the right row. Is it possible to automatically rename attachments as you upload them? With row number or…