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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 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!