RobNY2✭

Comments

  • Thank you very much! Rob
    inCount Date + N/A Comment byRobNY2 11/17/22
  • 基因vieve Thank you very much! I appreciate your help! Rob
    inAverage for both columns Comment byRobNY2 09/30/22
  • Lee I think the formula needs to change to give me the result that I want, so it would be something like: It is just the idea IF(AVG(ISDATE(column 1), 0.5), IF(ISDATE column2), 0.5), the result will me 100% but if there is "Cancelled" in (column 1) but a date in (column 2) = 100% or vice versa, meaning if one column has a…
    inAverage formula with error should give a blank cell Comment byRobNY2 09/29/22
  • Lee If I remove AVG =IFERROR(IF(ISDATE([Design Circuit Recommendation Actual]@row), 0.5) + IF(ISDATE([Design Velo Recommendation Actual]@row), 0.5), "") I am getting 0% now for Cancelled but I want blank because the formula says IFERROR- is not a date then " " There is something that I am doing wrong Rob
    inAverage formula with error should give a blank cell Comment byRobNY2 09/28/22
  • Jeff I think I found the solution: =AVG([Quote % Complete]@row, [Order Validation % Complete]@row, [Circuit % Complete]@row, [Equip % Complete]@row, [Intro & Discovery % Complete]@row, [Docs % Complete]@row, [TT % Complete]@row, [Go/no GO Pre Deployment schedule % Complete]@row, [Go/No Go % Complete]@row, [LAN Migration %…
    inTotal Site % Complete + health Comment byRobNY2 09/23/22
  • Dale I figured out the solution: =AVG(INDEX({Values for Equip Range 1}, MATCH([1st Equip Order Status]@row, {Values for Equip Range 2}, 0)), INDEX({Values for Equip Range 1}, MATCH([2nd Equip Order Status]@row, {Values for Equip Range 2}, 0))) Thanks for trying to help me! Rob
    inTOTAL% COLUMN Comment byRobNY2 09/23/22
  • Jeff What I found out is that I need average of all milestone columns % complete and not a SUM of them. If the cell has "N/A" the formula will skip that cell Rob
    inTotal Site % Complete + health Comment byRobNY2 09/20/22
  • Mike Also since you are smart and create good formulas. I have another formula that is not answered and I am stuck. If you have the time, I really appreciate if you could help me TASK % COMPLETE FORMULA — Smartsheet Community
    inTask Health Comment byRobNY2 09/17/22
  • Mike Repeating what I wrote based what L_123 suggested: I created another sheet and names the column B and "Values" and I named the column A as "Name" as it was suggested above but I still get Unparseable =IF([2nd Circuit Status]@row = “N/A”, index({Values},match([1st Circuit Status]@row…
    inTASK % COMPLETE FORMULA Comment byRobNY2 09/17/22
  • Mike How about creating a Completion column and adding that below so you would have something to refer to to keep Health Red after the task is completed the "Due Date". What do you think?
    inTask Health Comment byRobNY2 09/17/22
Avatar