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 had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
