JamesB · IT Project Manager · ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	28

About Me

About Me

Title	IT Project Manager
Industry	Technology
Area of Expertise	Smartsheets, Formulas
How I Use Smartsheet	Project Management, Team Metrics, PMO

Analytics

415

Posts

859

Visits

1.8k

Points

Jul 14, 2023

Join Date

Mar 3, 2025

Last Active

Reactions

• Insightful 10

  10
• Vote Up 89

  89
• Awesome 38

  38

• Activity
• Discussions6
• Comments409

• Re: COUNTIF for a date range - what am I doing wrong?

  JamesB

  03/21/24
  @Nat It was actually the spaces between your formula types and the parentheses. your post had: =COUNTIF ( but a formula needs to be connected: =COUNTIF(
  1 ·

• Re: Counting items from a multiple drop down list

  JamesB

  03/04/24
  @Amy A Try This... =COUNTIF({LL Action Tracker Range 1}, HAS(@cell, Section@row))
  1 ·

• Re: Count non-duplicate text cells

  JamesB

  02/27/24
  @TobiasKarlsruhe Create a helper column with the following formula. If([Indent Level]@row=1," ",COUNTIF([Customer Requirement]:[Customer Requirement],=[Customer Requirement]@row)) Then you …
  1 ·

• Re: Why is a formula not triggering unless someone opens the sheet?

  JamesB

  02/06/24
  @jmhoward I had a similar issue and use an automation. This action will cause a virtual open/close of the sheet which will update the formulas in the sheet. I created a column named date. Then I used…
  1 ·

• Re: Help using the NOT formula

  JamesB

  11/10/23
  @Emily Miller This should work for you... =COUNTIFS([PM Resourcing Score]:[PM Resourcing Score], >=8, [Approval Status]:[Approval Status], NOT(CONTAINS("Canceled by Specialist Team", @ce…
  1 ·

Next