-
Count the amount of Failing scores across a range of columns
I am trying to count the amount of Failing scores across a range of columns based on the customer that is selected. Currently I am able to count the amount of Failing scores for Atlanta from 1 column with this function: =COUNTIFS({ORA: Flight Observation 1 Customer}, ="Atlanta", {ORA: Flight Observation 1 Q1 Score}, ="1.…
-
How to connect Countifs with Jerarquies (Children?) with two conditions ( 100% & Dates )
Hello All, I am running this formula "=COUNTIFS([P%]:[P%], =1, [Finish date]:[Finish date], ISDATE(@cell))", And the result is "7", and that's correct!. But now I'm attempting to run a similar formula just for a specific cell "Abstract" and " Summary". Basically, I need the result for "Abstract" be "3" and for "Summary"…
-
Last value from INDEX MATCH
I am a smartsheets newbie, but have good experience with Excel and have been trying some things for an inventory management tool that I am creating. Typically in excel I use the following formula to pick the last value from INDEX MATCH and it works well to give me the last matching value in the range of C3 to C12 from the…
-
Sumif returning 0
I am looking up sales and wages hours for 7 different locations and the sales all work perfect for all 7 locations but the wages hours are only correct for 3 and on all the others it is brining back 0 instead of the correct amount for all the weeks. I have deleted and checked all formula's to make sure they are correct but…
-
Formula Question/ Help Needed
I currently have the following Formula updating a STATUS (Not Started, Complete, IN Progress) based on % Completed. Works flawlessly =IF([% Complete]272 = 1, "Complete", IF([% Complete]272 >= 0.01, "In Progress", IF([% Complete]272 = 0, "Not Started")) I want to take this to another level. As I have another column "Health"…
-
@ row used to determine month and year but summary formula is now invalid
Hi All, I have successfully created an @row formula to automatically populate in a cell in my sheet which is super awesome. For this example I am showing the Month Reported but I also used a similar formula for Year Reported. But now that I have that completed, my summary formula that previously worked no longer does. How…
-
Formula to check box if oldest milestone?
Hi there, I have a set of project plans that I wish to summarize in one report, and in that report I only want to know the oldest (aka soonest) milestone that is not completed for each project. To get to that, I figure I will have a checkbox column in every project plan, with a formula that checks the box if it is a…
-
Averageif and match for summary of info
I'm trying to average the the percent of submissions for an assignment on one Smartsheet based on a teachers ID in the current sheet. Here's the formula I've tried =AVERAGEIF({Quiz 1 Completion Avg}, MATCH(ID@row, {ID })) The results that are populating in my sheet do not match with are not correct. We have one sheet (the…
-
How to use =SUM(CHILDREN()) for all PARENT in the same column ?
Hello i would like to know how i can SUM a budget in the first row of PARENT regarding their CHILDREN. And then make it a column formula but for just the PARENT rows.
-
Days to Launch, stop at Zero
I have created a formula to countdown the days to launch and converted it to a Column forumula so it is automatic for any project. However, we don't need to know the negative numbers or day past launch in this column. I tried nesting an IF function to return a blank cell for anything less than zero but I the dreaded…