-
Complete % calculation issue
I’m having an issue with the % Complete roll-up in Smartsheet. In the File Storage parent row (line 10), two out of the three child tasks are marked 100% complete, but the parent row is still showing inaccurate % instead of calculating the summary correctly. Could you help check why the parent row is not calculating…
-
K-12 Education
Hello everyone, my name is Alan Miller and I am an Executive Assistant working in K-12 education in Grand Junction, Colorado. I would just like to introduce myself and share some of the uses of Smartsheet that I use within my industry. I have been using Smartsheet for 4 years now and just returned from my second time at…
-
In Control Center: Link Assigned to, to Project Team on Intake
I have Control Center. We are set up to where the project team is not entered when a new project is created. The column is there, but the requestor doesn't necessarily know how the project team is. As we build out the project plan, I would like to have everyone that is "Assigned To" a task, auto-populate the Project Team…
-
Control Center Find/Replace formula not working
I am trying to do a global update within our Blueprint on just one sheet in the summary section. All sheets have the same column name and the same row. We are trying to change the last "Description$8" to be "Description$12." When I look at the test sheet, it still has the "Description$8."
-
Formulas reading from ROW above.
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Dynamic Array Formula Help
GOAL: Create the most efficient formula that can drag across from Column "1" Row "2"and down as project budgets are activated (by form submission adding rows to the bottom of the sheet) and subsequently drawn down. Target Sheet has 60 project budget columns to the right of Project Kickoff, most blank, to allow additional…
-
Counting value repeats since last distinct value
Hi Smartsheet experts! I'm trying to accomplish something like the above, where I count the number of repeats of one value in a column, but that count resets when the value changes and resets to 1 if the same name appears later. This is to consolidate an order form where users can order different numbers of items- it's…
-
Merged: Capture a “Last Updated Timestamp” (Date + Time) for Specific Cells/Columns (Lockable)
This discussion has been merged.
-
% calculation for parent overview
In the above image the green is the parent line, where some are calculating the child line %'s below, however in the lower half of the image it's not doing so. Any suggestions please? Thanks!