Sign in to join the conversation:
=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
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.
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
Thank you seems to work now
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
