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 emplo…
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…
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 ful…
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 f…
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 woul…
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, Nu…
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 a…
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 projec…
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notif…
Is there anyway to stop updated cells being highlighted in pink for 1 hour after they have been updated? THe reason being is because whilst it is pink it is not possible to update the cell colour to a…