Formula Help - SOS

Taylar LaBonte ✭✭✭

02/10/22 in Formulas and Functions

I am not able to use the date in a formula and I am confused as to why the count is coming out as "0". Please advise!

Trying to count the number of buildings that are not owned by ABC Inc., and contract signed on 02/01/22.

Tags:

• Formulas

0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Best Answer

• 

  Sameer Karkhanis ✭✭✭✭✭✭

  02/14/22 Answer ✓

  Try this, hopefully that works:

  =COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )
  

  1 · Share on FacebookShare on Twitter

Answers

• 

  Sameer Karkhanis ✭✭✭✭✭✭

  02/10/22

  Try this,

  =COUNTIFS([Owner]:[Owner], <>"ABC Inc.", [Date]:[Date], DATE(2022,2,1))
  
  

  I would suggest to rename the "Date" column to "Contract Date" or so to avoid confusion with the system word/function name "Date".

  0 · Share on FacebookShare on Twitter
• 

  Taylar LaBonte ✭✭✭

  02/14/22

  @Sameer Karkhanis

  How would I change the formula to count the number of buildings that are not owned by ABC Inc. OR GreyBird, and contract signed on 02/01/22?

  Thank you so much!

  0 · Share on FacebookShare on Twitter
• 

  Sameer Karkhanis ✭✭✭✭✭✭

  02/14/22 Answer ✓

  Try this, hopefully that works:

  =COUNTIFS([Owner]:[Owner], AND(@cell <> "ABC Inc", @cell <> "GreyBird"), [Date]:[Date], DATE(2022, 2, 1) )
  

  1 · Share on FacebookShare on Twitter
• 

  Taylar LaBonte ✭✭✭

  02/14/22

  @Sameer Karkhanis

  Thank you so much!!

  0 · 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