=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
I work for a behavioral healty practice and we are interested in using this tool to manage several projects NON related to any patient or confidential information. We would have to integrate those record keeping systems for this to become an issue with compromising that type of personal data?
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
I have published a calendar in the past and end users could switch from calendar view to grid view. Has that option been taken away or do I need to re-save it in a new format? I am missing what I circled in the blue.
