I'm having a challenge where the total number of hours is not adding up to 1 day if the hours are equal to the "length of workday" under my settings
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 anything else which is fustrating. woudl appreciate some help on this brook
When I copy a row from one sheet to another sheet; all the formula's in the cells are replaced with values in the target sheet. So my formulas are gone in the new row that appears to the target sheet. Is there a way to have the formulas copy over in the row so they are intact in the target sheet?
Hi, I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not. I'm using the construction timeline with gant chart template. I would like to add project management fee payment dates as milestones. Payment #1 linked to start of the project -> OK, no problem Payment #3…
I'm creating a couple of web forms with a single smartsheet. Each one will capture slightly different details. The forms are sort of like a helpdesk queue, where the users can have different requests, but ultimately all the work goes to the one helpdesk team, and the work is all 'queued' into the smartsheet, and from…
I would like to know if I can have a cell in a row that updates with the current date when anything in that row is changed - kind of a "last time updated" cell. It will allow me to track stale rows. Thank you.
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
Howdy! I have five sheets that my regional teams update about their current status of projects. I am wanting to create a report that shows a breakdown by count of each region. For example, if the West Region has 10 active projects and the Central Region has 5, I would like a report that would pull data from both sheets and…
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
Something seems to have happened with the prorate function in the new release, or perhaps it was always like this and I just never noticed (in which case I apologise). I use the prorate function to provide linear projections of task completion. In other words I calculate what the completion percentage of a task should be…