I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
I have a Gantt Chart with dependencies enabled. When I shift the entire start date of the project all the dates shift appropriately so I believe it's working well. I've just inserted a new row and assigned a Predecessor Row and Duration. The bar appears to the right and dependency lines are drawn. However the Start and End…
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
We have a vendor who is assisting us with a project and he already has smartsheet. Is there a way for him to have access to our sheets as well with his login or is that not allowed where we would have to setup another account with a new email for him? Did a search and couldnt find same question so bare with me if a…
I am trying to set up a sheet that tracks employee hours for the week and any overtime or stop out allowance, has anyone found the best way to do this? Ideally I'd like to use a web form so each employee can pick up the web form, enter their information and it be transferred to a sheet for payroll. Many thanks
I need to give per diem to employers for days worked for two events. Some will work one, some will work both. I have a formula that works great if they are working both events, but get the #MISSING OR INVALID PARAMETERS" message when only one event is worked. Does anyone know how I can get a column to return a "0" date?…
Is it possible to produce a Gantt Chart with costs? ie as you add Parents & Children the Parents Costs row will total the Children Costs row Have tried various formulae but other than building the full Schedule then adding formulae to each Parent row it seems to be a long winded method of populating the costs. Can anybody…
Hello, I am looking for a way to make the % complete on my parent rows reflect only work that takes effort, rather than processes that are just elapsed time. For background, my group uses smartsheet for project management purposes, but we also use it for billing. Our parent rows in our project sheets are all billing…
