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
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
Hi Everyone, I created some forms for our powdercoat test logs. The forms are working great for the employees to input the data. The problem I am having is with giving the supervisors and managers access to the sheet. I gave them Editor Cannot Share permissions to see and edit the sheet. But they are saying that Smartsheet…
Hello There , before smartsheet switched to the new license type, the users to whom I gave editing permissions could not share the page unless I granted them permission. In addition, users did not have the ability to create pages. This way, as the admin, I was aware of all the pages created in the company and could…
