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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!