Hi- I have been doing some searching on the community and cannot find a clear reason or explanation as to how to to set up the "Optional: Define Row Groups" I cannot find any documentation or help vid…
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "a…
I am trying to display a date in a metric on a dashboard, all the sheets have the date displaying DD/MMM/YYYY but the metric displays DD/MM/YY. How do I get the metric to display the date in the forma…
I recently used one of the existing templates "Contract Management" under the Client and Customers in the Solution Center, and it worked great. However, When my users get a notification the header sti…
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the f…
Hi, I created a grid, with each row in the grid representing an individual project. I set the predecessors between the various rows, so Smartsheet draws the links between the various projects. I need …
Hi Guys, Im new to smartsheet , please help me. I created an approval workflow then if the approver is not around how I am going to reassign it to other approver without breaking the approval sequence…
I'm having issues with the following formula and I'm not sure why. Task Formula below: =IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Dat…
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # +…
I was sent a Smartsheet project and am not sure how it was constructed. The % complete column for the child tasks have the amounts entered. The parent task does not report the calculated rollup from t…