Countif with blank cells

Sabrain

Sabrain ✭✭✭

12/01/22 in Smartsheet Basics

I want to count if the cell of one sheet fits the cell of another sheet. I also want it to fit when both cell values are empty (blank cell) How does it work?

=COUNTIF({Entnahme Bereich 5}; HAS(@cell; (Ansatz@row)))

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

12/01/22

Are you able to provide screenshots for reference?

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Attachments and Row Locking
I'm admin level on all of our sheets, so it's sometimes hard to test out user-level features. Can anyone let me know if users can add/delete row attachments after the row has been locked?
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…

Help shape the future of Smartsheet.
Share your ideas and feature requests.