I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation?
I cannot see how to do it.
I have a flag column that I want to let the users manually set to highlight what needs to be looked at and also have the flag set automatically when certain conditions are met.
I can't use a formula for this as the user would not be able to manually set it without wiping the formula.
Is there a way to do this or is there a plan to include flag/symbols in the automation?