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…
I would like to be able to have a calculation take place in a report that is based on numbers in cells from two different spreadsheets. Any ideas? Not keen on linking for this application as that would require multiple linking of new data, which would have a higher probability of user error.
I currently have smartsheet connector to DOMO to create reports; however, the columns that contain financial data come over as text because smartsheet's column properties are Text/Number. Not Text, Number separately. Anyone know how to make this work? or a workarond? Thanks
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
