IF(FIND Function with AND

Hi Everyone,

I have created a formula which works well with locating and counting text in a range - "COUNTIF([Functional Area]:[Functional Area], FIND("Accounting",@cell)>0)". This formula counts the total number of items irrespective of the status of the item, which could be for example, New Demand, In-flight, UAT, Complete, etc. As such i need to run the formula above and include the AND statement. For example ""COUNTIF([Functional Area]:[Functional Area], FIND("Accounting",@cell)>0) AND (Status:Status, " New Demand").

Any help creating this formula would be appreciated.

Thanks,

Steve

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!