Good day! We are looking to change our current system of work orders (creating it manually on a hard copy) to doing it via Smartsheet. There doesn't appear to be a template already in existence. Has anyone ever created one? One of our primary concerns is how do we get a customer to authorize the work? Thanks Rob
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…
Hello all How can I copy a row with drop downs and formulas to another sheet, when I copy these the formulas dont work, I have tried copying the row and selecting all cells but nothing works Thank you in advance
I am try to go from a proposal to a detail sheet for our business. We make doors and you can have from 1 to about 100 or more of one type of door. On the proposal it is only shown as one line with a quantity cell. Now what I want to do it link that to a detail sheet, the sheet that will go to production, and list those…
I'm using SmartSheets for residential construction project management. I would like to be able to attach a material takeoff sheets to rows where a material list is needed. Once done we could manage budgets and cashflow, as well as verify correct amounts, in the office by consolidating the material take off sheets on a…
I am trying to create two templates that have cell links from sheet to sheet but when I save the documents as a template (or another file name) the links dissapear. Is there some way to retain the links?
Is there a way to change the font color of items in a dropdown list in a web form? Example: My guy is filling out his web form and under the field for "Fire extinguisher is on site" he has an option to put either yes or no, can i make "no" red so that when he submits his form it will stand out in the spreadsheet?
I am intersted to get smartsheet but would like to know if any body has used it with Microsoft projects . as my projects are been managed by MSP and I would like to link it with smartsheet
Just trying to understand my options. I use zapier right now but keep hearing about azuqua. Any advantages of one over the other? Thanks
Hello, I want to know if I can measure the performance of my team, crossing plan versus real in terms of the total time of the project.