DKazatsky ✭✭✭✭

Overview

Overview

Roles	Member
Badges	8

About Me

About Me

Not much happening here, yet.

Analytics

43

Posts

92

Visits

161

Points

Jan 11, 2023

Join Date

Mar 10, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 2

  2
• Awesome 5

  5

• Activity
• Discussions2
• Comments41

• Re: Using COUNTIFS to reference another sheet

  DKazatsky

  02/24/23
  @JoanH Remove the @cell and this will work: =COUNTIFS({Project plan status}, Label@row, {Projects incoming year}, "2023") -Dave
  1 ·

• Re: Dates & Helper Coloumn

  DKazatsky

  02/14/23
  Hi @pturnbull You shouldn't need to use AND with a COUNTIFS. Try something like this (untested): =COUNTIFS({Start Date}, >= DATE(2023, 1, 1), {Start Date}, <= DATE(2023, 12, 31), [Helper],1) Al…
  1 ·