- Row to Form Creation
Hi all, I'm trying to set up our production planning schedule on Smartsheet. It looks like it is going to work well however I've got to an impasse... My standard sheet has 15 columns with information necessary for every job. Every row is a different job. What I need to be able to do is highlight a row, then print this row…
- Individual Days Off
Is there a way that I can schedule individual days off and have them reflected in my Gantt charts? I know the options are available for across the board, but what about individual vacation days. Thanks!
- Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
- Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
- Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…
- How to select different image source (camera app) when adding photos
Hello- Is it possible to default to a different camera in Android app when selecting to take a photo. By default the smartsheet app uses Android camera. I would like to use Skitch so we can add notes, arrows, circles, etc. to the photo. We are using this for a production line checklist. THANK YOU!
- Convert gannt chart into monthly revenue forecast
我新的内容,我想build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
- Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
- AUTOMATIC Weekly Reminders
I've created a Meeting Agenda sheet that will be used during our weekly meetings. I'd like everyone shared to that sheet to receive a weekly reminder. How can I set this up to automatically send out?
- change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike