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 Community Champion

12/01/22

Are you able to provide screenshots for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Can you schedule reminders in Board View?
I'm trying to transition myself to using Board and Table view over Card and Grid view, but haven't been able to figure out how to schedule reminders in Board view. Is there a spot on each task to create a reminder the way there is in Card view that I'm missing? Or is this feature just not available in Board view yet?
Form's Created By
Is there a way to default a "Created By" field to be whomever submitted an entry via my form. That is, rather than having a drop-down list of contacts for the submitter to pick their name from, I'd like the system to just automatically populate to whomever is logged in to the form.
How to add contacts in bulk in Contact List - Restrict list to values only
Hi there, I'm working on building a request form for my team. I'd like to add all 85 members as contacts in the Contact List field, and Restrict to list values only. How can do this in bulk without having to manually type out/select each name in the Add contacts lookup? Help?!

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