-
Decimals appearing in Parent Rows for "% Complete" instead of a % value
Hello! I've included the screen shot below. The parent rows at the top are rolling up to a % value, but as you can see, the other parent rows below are displaying as a decimal. The child rows under the parent are displaying % complete correctly. I cannot modify the roll-up values. Any idea why this is happening? Thanks so…
-
Trying to evaluate a range for a value in random positions
I've been trying for a few days to stitch a formula together with multiple tools but I'm coming up short. I have a form that leverages logic so that a specific option-set value selected, produces a sub-set of options. Thus, for each value in the option set, there is a corresponding sub-set that only displays when that…
-
Need a second pair of eyes on this formula please
Ok, I'm going crazy. I have used this formula 3 times already on my roll up sheet and it's working just fine, but suddenly I'm getting an INCORRECT ARGUMENT error. I've been staring at formulas all day...am I missing something here?? =COUNTIFS({Program Schedule - Shell Mobility pt 4 Range 1}, "Stage 2", {Program Schedule -…
-
Calculate Average Time
Hi Team, I have one sheet that calculates the time duration that a tech is onsite per line, but what I need to do is in another sheet calculate the average time TOTAL for all entries. I'm having trouble figuring out how to accomplish this. Thanks in advance for everyone's assistance!
-
Calculate Expected completion %
I have added a column to my project plan template to calculate expected completion %. I want to the parent level rows to calculate an average based on the children. I'm thinking I need to add an IFERROR... =IF(COUNT(CHILDREN()) > 0, AVG(CHILDREN()), IF(Start@row < Today@row, MIN((Today@row - Start@row) / (Finish@row -…
-
Possible to have two IFERROR values?
I have an IFERROR formula that is working correctly., However, I was wondering if it was possible to add an additional IFERROR option. So, for instance, This formula works perfectly: =IFERROR(INDEX({EventTitle}, MATCH([WE ID#]@row, {ID}, 0)), INDEX({EventTitleComp}, MATCH([WE ID#]@row, {IDComp}, 0))) My only problem is…
-
Formula to reverse order of column
Hi, Is there a formula in smartsheet to reverse/flip the order of a column from A B C to C B A This can be done in excel using an INDEX and ROWS function: =INDEX($A$2:$A$80,ROWS(A2:$A$80)) however it doesn't seem that SmartSheet has a ROWS function. Thanks! -Junn
-
Countif status is "In Work" and Multiple choice contains
Hello All, I am trying to establish a Countifs formula that first checks status, then looks for a specific multiple choice option. Is this possible? =COUNTIFS({AD-CVT Disc Status}, "In Work"), ({Above Findings}, (CONTAINS(Primary Column]@row, @cell)) Any help is appreciated! Thank you.
-
How I find the first column?
I have a range of columns with 14 milestones. If the milestone reached, then it will be delete and the cell is blank. Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range. Any ideas, which…
-
Status circle and IF function based on dates
Not sure if this can even be done, didn't find a clear answer in a search. I want a status column that automatically chooses the colored circle based on the dates of "Potential Start" column already set up. I want it to show the Green light if the P.S. date is more than a week out Yellow if it is less than a week but still…
