Formula Issue

Shaun Bailey

Shaun Bailey ✭

05/29/24 edited 05/29/24 in Formulas and Functions

So this Formula works =COUNTIF({Skills}, [Primary Column]@row) and this works as well =COUNTIF({Month}, 5) but when i combine them =COUNTIFS({Skills}, [Primary Column]@row, {Month}, 5) I get #IncorrectArgument Set. Why is this?

Tags:

Formulas

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

05/29/24

Are both cross sheet references pointing to the same sheet? Are they both single column ranges?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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

Sum a column associate with children
I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help would be appreciated and thank you very much…
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
Reporting & Metrics
Typically we try to use a report to update our Hypercare Ticket Log. This strategy helps us maintain a clean log and keeps the noise down. What we are finding though is though all members have "Editor" rights in the report, they are not able to create filters or sort the report when they are working. The report needs to be…