I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into…
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all use…
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on tha…
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized.…
I'm trying to find a way to do what I've done with spreadsheets before, but I am not seeing a way to do in Smartsheets. In some of my fields, there are instances where I won't have a value. I populate…
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I n…
Hello. I have a report that pulls milestones from multiple project plans. I created this report from a template within Smartsheet. There are two columns named 'Assigned To' Can you provide any answers…
It would be awesome to be able to send out recurring attachments in which the pdf attachment is based on a filter. For instance, if it was a construction schedule and I wanted to send out a recurring …
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencin…
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using f…