The Formula in sheet summart is coming back #Invalid Value

Louis.Smith

Louis.Smith ✭✭

09/01/23 in Formulas and Functions

The formula I tried is:

=COUNTIFS(Client:Client, @cell = "Delta")

The Delta value came from a formula pulling data from another sheet

0 ·

Answers

jmyzk_cloudsmart_jp ✭✭✭✭✭✭

09/01/23

Hi @Louis.Smith
Your formula looks OK.
I was not able to recreate your #invalid value error.
Strange.
Please take a look at my demo Dashboard.
https://app.smartsheet.com/dashboards/5q6j4RGRCMMxM5fHqWxFf75gMv8rX8px5QwfcGV1

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

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…