-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Gants - Resource allocation, Assigned Groups.
Hey there, new to Smart Sheet and have a question. I'm building gantt charts for some of our projects. I’d like to be able to account for the amount of people that belong to a group/resource to properly scope the amount of time needed for each task. For example, one task within the Gantt would be ‘Fabrication’ – I assign…
-
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Email notifications for all changes
I have an employee getting notifications for everybodys changes but he only wants emails sent to him that involve his changes. Is this possible?
-
Can the Live Data Connector work with QuickBooks desktop, QuickBooksOnline or Xero.com?
We currently use SS for all of our project estimating. We love it. We are currently exploring using SS to also produce our job cost estimate versus actual reports. (construction company). I see a couple of options. First, we can pursue a "one way" push utilizing zapier.com to auto entry into a spredsheet that could be…
-
Does anyone have any great manufacturing process systems
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to refresh our processes. It is time to do this so any shared ideas would be great.
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Automation / Update Request
Is it possible to set up an Automation / Workflow which will send a weekly reminder of any Update Requests that haven't been completed?
-
Can viewers of a sheet use the barcode search function?
I have viewers that are being sent update requests for tools that are allocated to them. It would be good if they can barcode scan an item to see if its the one they are allocated to.
