COUNTIF FORMULA HELP

Is there a better way to pull only the previous year data?

COUNTIFS({M&A Program Interest}, CONTAINS("Buyer Consult", @cell), {M&A Intake Form Range 1}, @cell > TODAY(-360)


Current formula above

Answers

  • Alpha Chucky
    Alpha Chucky ✭✭✭✭

    Hello @tmagana Just to clarify, are you looking to pull a year from current date or "2022" data? if its the later, I think you can parce your desired date column for the year. =YEAR([DateColumn]@row).

    If your looking the phrase "Buyer Consult" in 2022, than your formula can look like:

    =IF(AND(Year@row = 2022, [Range 1]@row = "Buyer Consult"), "Match", "No Match")

    Let me know if this did the job or got close. LOL!!

    I'm not exactly sure the results you want to produce.


    Projects Delivered. Data Defended.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!