Countif formula that counts that row if the date on one column matches the date on the other column?


This is my formula so far and I would like to add on to it - =COUNTIFS({Proj. Type_}, <>"OTU", {NTP}, AND(@cell >= DATE(2020, 10, 1), @cell <= DATE(2021, 9, 30))). How do I add on to this formula so that it counts it when it is 15 days and more?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Unfortunately not at the column level. Are you able to reach out to whomever can add that to the source sheet and have them add then hide it for you? The formula would be

    =RWA@row - NPA@row

    Then right click on the cell containing the formula and select the option at the bottom of the menu to "Convert to column formula". Then hiding the column will make it look like it never happened and shouldn't take but a minute or two to set up (in case they are worried about spending a bunch of time on it).

    Then in your metrics sheet, the formula would be:

    =COUNTIFS({Proj. Type_}, @cell <> "OTU", {Helper Column}, @cell >= 50)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!