SmSulli✭

Comments

  • No, if both are blank, "No Follow-up Date" will show. Check that the rows and columns are correct. Shawn
    inAutomate RYGB based on Follow-up Date by Week Comment bySmSulli 10/13/17
  • Here you go... =IF(OR([Date Closed]1 <> "", Status1 = "Resolved"), "Blue", IF(AND(Status1 = "", [Follow-up date]1 = ""), "No Follow-up Date", IF(WEEKNUMBER([Follow-up date]1) = WEEKNUMBER(TODAY()), "Green", IF(WEEKNUMBER([Follow-up date]1) = WEEKNUMBER(TODAY()) - 1, "Yellow", IF(WEEKNUMBER([Follow-up date]1) <…
    inAutomate RYGB based on Follow-up Date by Week Comment bySmSulli 10/12/17
  • Hi, Here's a formula for you to try. This will go in the RYB column. =IF(WEEKNUMBER([Follow-up date]1) = WEEKNUMBER(TODAY()), "Green", IF(WEEKNUMBER([Follow-up date]1) = WEEKNUMBER(TODAY()) - 1, "Yellow", IF(WEEKNUMBER([Follow-up date]1) < WEEKNUMBER(TODAY()) - 1, "Red", ""))) Not sure what you wanted for weeks in the…
    inAutomate RYGB based on Follow-up Date by Week Comment bySmSulli 10/10/17
  • Use this formula in the column next to your Status column. You'll need to change the column name in the formula. and customize it so it says what you need. =IF(Status1 = "Red", "Late", IF(Status1 = "Yellow", "On Hold", IF(Status1 = "Green", "Active", ""))) Good Luck Shawn
    inLabels for RYG Balls Comment bySmSulli 10/10/17
  • Hi Shawn, Not sure how you've got things set up, but I'll give you some ideas. You need to have a list of branches and address somewhere in the sheet. See the screen shoot. Then use that list for the lookup formula. With the Branch # as a dropdown. The formula for the address column: =LOOKUP([Branch #]1, $[Branch #…
    inUse Dropdown column to populate an alternate column in a sheet Comment bySmSulli 10/09/17
  • Randy, Take a look at your formula. You've got one cell labelled as row 1, instead of row 150. Give that a try Shawn
    inProblem with date cell being blank Comment bySmSulli 10/06/17
  • Randy, Take a look at your formula. You've got one cell labelled as row 1, instead of row 150.
    inProblem with date cell being blank Comment bySmSulli 10/06/17
  • I'll give this a shot. You let me know if this works out. This formula will go in each parent Top Level Task row, in the "Status" column. It will count each color and show in the parent row. ="Red-" + COUNTIF(CHILDREN(), ="RED") + ", Yellow-" + COUNTIF(CHILDREN(), ="YELLOW") + ", Green-" + COUNTIF(CHILDREN(), ="GREEN")…
    inCounting number of tasks, by top level then by RAG status Comment bySmSulli 10/05/17
  • Hi! You have a few too many parentheses. I'm not sure this is correct as you didn't specify all the parameters you needed for each result. But I think I cleaned it up for you. Also, there was no final Else result, so I added 0. =IF(AND(ISBLANK([Last Follow-up Date]1), ISBLANK([Work Order Date]1), [Estimate Creation Date]1…
    inNested If Statement Comment bySmSulli 10/03/17
  • Hi, Here is a formula that will force a 0 on to single digit months. But is will make the number text. So this may not be helpful. You didn't specify the column names, so you'll need to change that in the formula. Give it a try and let us know if this helps, or if you need something else. Is there a reason why you need a…
    inDay or month as 2 digits Comment bySmSulli 10/03/17
Default Avatar