how to make my formula count two things?

Diego Casillas Zaragoza

Diego Casillas Zaragoza ✭✭

05/12/21 in Formulas and Functions

Hello,

I am currently using this formula =COUNTIF({CP Daily Shipment Count Dump Range 1}, "yes1") to count all my yes1. I need to also make it count yes2. but I don't know how to incorporate that into the formula.

0 ·

Best Answer

Diego Casillas Zaragoza ✭✭

05/12/21 Answer ✓

issue resolved!

0 · Share on Facebook Share on Twitter

Answers

Diego Casillas Zaragoza ✭✭

05/12/21 Answer ✓

issue resolved!

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Divide by Zero Error With AVG(COLLECT(...
Hoping someone can help because I am totally twisted with this one. I don't use AVG(COLLECT very often so I may be missing something simple here… What I'm trying to do is take the average of Column17 where both the year (Column22) and the weekday (Column9) match the year and weekday that I've indicated in Column21. (Yes I…
Formula to Check Restricted items in a Multi List Drop Down
I have a field "Failure Summary" in a sheet that has a drop down list that allows multiple selections. I want to write a formula that will check mark those specific items in the drop down list, if a corresponding column@row has "NO" as the value in that field. Is it possible to write a formula to do this?
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…