Skip to content
Discussions
Topics
Support
Product Ideas
Help & Learning
Sign in
Try Smartsheet
Shelvia
Shelvia
Clear
Search
Loading
Home
›
Shelvia
›
Discussions
Shelvia
✭✭
Overview
Overview
Roles
Member
Badges
6
About Me
About Me
Not much happening here, yet.
Analytics
4
Posts
3
Visits
225
Points
May 20, 2022
Join Date
Dec 15, 2023
Last Active
Reactions
No reactions yet.
Discussions
1
Comments
3
Discussions
Count Ifs Specific Year
I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024. =COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 202…
Answered
Cell Reference Limits
Countif
Formulas and Functions
161
Dec 15, 2023
6
Discussions
1
Comments
3
Badges