Count if Name and past date.

Jason P ✭✭✭✭✭

07/07/22 in Formulas and Functions

Hi all..

I'm at a loss here, keep getting #unparseable

=COUNTIF([Assigned To]:[Assigned To], "Karl"),and([Completion date]:[Completion date], <=TODAY())

Cheers.

Cheers.

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Emilio Wright ✭✭✭✭✭

  07/07/22 Answer ✓

  @Jason P If you have multiple criteria to evaluate, you will need to use the COUNTIFS() formula instead.

  
  

  =COUNTIFS([assigned to]:[assigned to], "Karl", [completion date]:[completion date], <=TODAY())

  0 · Share on FacebookShare on Twitter

Answers

• 

  Emilio Wright ✭✭✭✭✭

  07/07/22 Answer ✓

  @Jason P If you have multiple criteria to evaluate, you will need to use the COUNTIFS() formula instead.

  
  

  =COUNTIFS([assigned to]:[assigned to], "Karl", [completion date]:[completion date], <=TODAY())

  0 · Share on FacebookShare on Twitter
• 

  Jason P ✭✭✭✭✭

  07/07/22

  Thank you @Emilio Wright

  Cheers.

  1 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list