-
Sum children with one child omitted
I am struggling with a formula that I thought would be easy. I want to sum all children of Total column while omitting one child (Taxes & Freight). The purpose of this is to then multiply it all by Tax and Freight mark-up % (Qty2051) . Obviously I can manually add the various children by referencing the row numbers, but I…
-
No AVERAGEIFS so I tried AVG(COLLECT) but can't get it to work with multiple criteria
Hi, I'm trying to calculate the average of the operational speed [plants/h] only if the [job type] is "Grafting TOM" (cells highlighted in yellow) and also IF [week NO] is a certain value: so basically the average speed for each week for each job type. This formula will be on a different Metrics sheet on the same folder…
-
Adding numbers in a column that are links to other sheets
Good morning/afternoon everyone. I am just stumped. Looked throughout the community and I'm not sure what is wrong. I have several columns on what I'm calling a master tracking sheet that pulls info from 32 other individual sheets. I have used the same formula for each of the columns however the first column "open for…
-
Formula to Find Completed Tasks within One Month or Three Months
First post, pretty new to Smartsheet, need some assistance with a formula. I'm trying to Create a Sheet Summary formula to calculate the amount of Tasks completed within a month and quarter so I can represent that information as a graph in a dashboard. Any help would be much appreciated! Thanks!
-
Cross Sheet Referred Cells - Formula not working
I had received an email saying that the limit to cross-sheet referred cells in a sheet have been increased to 100,000. However, when I use formulas such as COUNTIF, etc with the reference range from another sheet. I still get the following message: How to fix this ?
-
Set a row to 'not applicable'
Hi. My project contains 3 sheets to represent network areas and includes the site locations within the networks. The project tasks are the same and include deployment stage gates and user adoption stage gates. We would like to use the same set of stage gates across all of the network areas for consistency and reporting,…
-
One VLOOKUP cell gives me a column list of returns
I am looking to have a drop down cell called "run name" that when changed will populate all the stores on that run. I was using VLOOKUP from a master store/run sheet to do this but could only figure out how to get one store to populate rather than the entire list of stores. Any help with this would be appreciated. Thanks…
-
SUMIFs with Children in a specific criteria
Hi SS Community, Hope everyone is staying safe in the current way of living. I'm looking towards you for help with what seems a fairly simple problem. I want to calculate the allocation % of a Project Manager, for projects that are "Current". The Projects are set up as children under the project manager name. Please see…
-
How do you extract numbers out of a cell and create a chart with the data
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time" and then on possible another sheet show a chart of over a period of time. I was even thinking, I could…
-
RYG and Gray!
Hey, I cant figure out how to add to this formula. I have this formula that someone shared from a seminar: =IF(AND([End Date]@row + 1 < TODAY(), [% Complete]5 <> 1), "Red", IF(AND([End Date]@row -2 < TODAY(), [% Complete]@row <> 1), "Yellow", "Green")) . This give me my r,y,g health in the right time frame i want. What I…