Go to the sheet properties (right click on an empty space), click on Triggers, OnActivateSheet, and add a new action, type Selection, and set the field and the value. This way anytime the user clicks the sheet (that means activates it), this selection will be done, although the user will be able to clear it, or do a new selection.
I select the field and what do i right in the seach string as i thought it would be one of the options in that field drop down box but when i type one in it doesnt work. Does it have to be written in a specific format
If you just want to show once field value selected when you open that document then you can just click some value on the field and then save the document.
Now everytime you open the document you will see the value selected. So your chart will show the data. But make sure everytime you save the document the value from the field is selected.
Regards,
Kaushik Solanki
Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Are you writing more than one value or using a function? If that's only a value of the field, it should work just typing it. But if it's a result of a function you will need to use some different syntax:
=Date(Today())
Or two different values:
(Value?A|Value?B)
You need to specify the "?" or "*" if there is a blank
.png "Miguel_Angel_Baeyens"){kind=avatar}
