nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

How to count symbols in smart sheet ? example the risk flag

Preetha Luther

=COUNTIFS({Main Deck Range 1}, "Body", {Main Deck Range 2}, [34 System - Unassigned]1, {Main Deck Range 4}, <>"", {Main Deck Range 8}, 1)

This formula doesn't seem to work Range 8 is the reference to the column that has the symbols

Find more posts tagged with

Manufacturing

Comments

L_123

double check the range and make sure it has the same size range as the others. Flags are referenced as 1 or 0 so the syntax seems to be correct, it is most likely the reference causing the issue.

Mike Wilday

What symbols column are you using?

You have to know what "Text" is being used to create the symbols in the symbols column and then you can reference that text to check for the symbol.

There are some clues here: https://es.smartsheet.com/node/2217

and this one also gives some clues: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls

This one also has a few clues: https://community.smartsheet.com/announcement/working-symbol-formulas

Preetha Luther

Thank you seems to work now

Sign in to join the conversation!

Quick Links

Trending discussions

Blueprint Workspace Title Change
Hi there, I have just recently worked with Smartsheet's Implementation team to build a Control Center Blueprint. The workspace that holds the solution is titled something very generic and I would like to rename it. Can I do that w/out breaking anything or what steps would I need to take to successfully rename it. Thanks in…
DataMesh - how to auto-clear backlog?
Hey, I've got a sheet, which is autopopulated as a source sheet to feed into DataMesh (which runs once every 24 hours). Once DataMesh has run, how can I auto-clear the rows in the sheet to avoid repeating this the next day? I have no use to keep the data and want to avoid clogging up the source sheet. I have tried…
Approval Request Auto Declined after opening the attachment
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…