-
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…
-
Is there a way to create a list out of joined string in a cell?
I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child. Example: Parent ID .........|........Task Description [blankcell]........|........Parent 1 [Parent 1].........|............Task 1 [Parent 1].........|............Task 2…
-
Count Distinct Values in a Column
I have a serial # column that I am trying to create a "helper" column to verify that the serial # entered is unique - to avoid/flag duplicate entries with conditional formatting later. I have tried this formula in the blue highlighted cell pictured below: =COUNTM(DISTINCT(([Computer Serial # (Parent Asset)]:[Computer…
-
INDEX/Match Problem Across Sheets
Here is my problem: I'm trying to compare dates on sheet A to a list of dates on Sheet B and if the dates match, fill in a number on sheet A. If I move the data over to sheet A and use this formula works fine: =INDEX([Column9]:[Column9], MATCH([Column4]@row, [Column8]:[Column8], 0)) When I use a cross sheet reference I get…