Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

click to new sheet without button

I need to click on one cell of a column in a Straight Table (CH83) of my sheet 1 and, automatically, going to sheet 2.

How I can do this?

Can you help me, please

Best Regards

Nancy

15 Replies
Not applicable
Author

See attached.

Not applicable
Author

Thanks Rebecca!!!

Anonymous
Not applicable
Author

1 – To set the sheet condition go to sheet properties > general you will see a radio button under Show Sheet

       Click Conditional and add your equation in there

        I use =if(GetSelectedCount(FIELD)=1,1,0)

2 – To set the button condition go to button properties and in enable condition add the same equation – this will mean the button stay there but is greyed out and not useable till a selection is made

      It is possible to make the button not there but that involves variables which will take a little longer to put together an example and instructions so try this and if it doesn’t suit let me know.

Not applicable
Author

Thanks Bella,

Not applicable
Author

Bella:

I did it!

Thanks a lot!

NavinReddy
Creator II
Creator II

Thank you so much Rebecca, you application made may day

Great