Thehidden global attribute is an enumerated attribute indicating that the browser should not render the contents of the element. For example, it can be used to hide elements of the page that can't be used until the login process has been completed.
Hidden elements shouldn't be linked from non-hidden elements. For example, it would be incorrect to use the href attribute to link to a section marked with the hidden attribute. If the content is not applicable or relevant, then there is no reason to link to it.
It would be fine, however, to use the ARIA aria-describedby attribute to refer to descriptions that are themselves hidden. While hiding the descriptions implies that they are not useful on their own, they could be written in such a way that they are useful in the specific context of being referenced from the element that they describe.
Similarly, a canvas element with the hidden attribute could be used by a scripted graphics engine as an off-screen buffer, and a form control could refer to a hidden form element using its form attribute.
The hidden state indicates that the element is not currently relevant to the page, or that it is being used to declare content for reuse by other parts of the page and should not be directly presented to the user. The browser will not render elements that are in the hidden state.
Web browsers may implement the hidden state using display: none, in which case the element will not participate in page layout. This also means that changing the value of the CSS display property on an element in the hidden state will override the state. For instance, elements styled display: block will be displayed despite the hidden attribute's presence.
In the hidden until found state, the element is hidden but its content will be accessible to the browser's "find in page" feature or to fragment navigation. When these features cause a scroll to an element in a hidden until found subtree, the browser will:
Note that browsers typically implement hidden until found using content-visibility: hidden. This means that unlike elements in the hidden state, elements in the hidden until found state will have generated boxes, meaning that:
Also, the element needs to be affected by layout containment in order to be revealed. This means that if the element in the hidden until found state has a display value of none, contents, or inline, then the element will not be revealed by find in page or fragment navigation.
In the hidden until found state, the element is hidden but its content will be accessible to the browser's \"find in page\" feature or to fragment navigation. When these features cause a scroll to an element in a hidden until found subtree, the browser will:
I would love to have a collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be hidden without unhiding everything and needing to re-hide it again.
Current functionality to hide and unhide columns is not very efficient. Suggesting a better interface to show/hide columns just like Smartsheet has in Reports to select columns to be displayed. See below,
If columns could have a 'Hidden' attribute in their column properties like in Forms, then we could have a 'Hide Columns' option in the right-click column menu, instead of only 'Show All Hidden Column' and then no efficient way of re-hiding them all.
The system allows users to hide columns individually or in blocks - good. Unhiding those columns - bad. There are currently only two alternatives to unhiding columns - unhide all, which is ridiculous overkill that requires users to then unhide all the unwanted columns, or unhiding them one at a time by dragging the vertical column separator. This second option is inefficient in that it's one-at-a-time, and undesirable in that unhiding is a manual drag that does not preserve the previous column width. There should be an option to select a block of columns and unhide all columns in that range at the previously saved column widths.
Perhaps not exactly what you are looking for, but a handy trick I recently learned from a colleague relative to your second point; give the columns you want typically hidden a gray (or some other) background color. That way, when you unhide all, it's easy(er) to hide them again without having to (again) think through whether each column should be hidden. This is something I now do on every sheet I create and it is super helpful.
That's an interesting way to manage it. I current use gray for columns that have automations attached to them, meaning "don't fill this out, it will be filled out automatically". I use other colors to mean other things; having a color assigned to typically-hidden rows is definitely something to consider.
I can see this potentially getting a little confusing if you move rows from sheet to sheet (like I do - I have 1 workflow sheet per phase of our workflow, so rows move from workflow to workflow and take all their columns with them as they go). I also copy rows to sub-sheets to track more specific items.
I like the idea of using to indicate automations will populate. Thanks for sharing. What I had been doing similarly was highlighting fields a certain color relative to the group that is expected to populate them. Ie. project team input vs. PM. That said, I like to limit the amount of colors on my sheets...I think it was a Smartsheet webinar that made me aware of how this can result in something I think they called a clown sheet....too many colors, degrading the effectiveness of any of the colors.
To solve the challenge you note, I would try using conditional formatting. First, on the source sheet I'd set the column colors instead of setting it manually to check whether formatting set conditionally carries over to the new sheet. If it does, set new conditional formatting on the destination sheet.
PLEASE! I love this idea. I dislike needing to unhide ALL or guessing which ones to expand and then recalling which ones to then hide again when I am through with a review. Currently my work around is to add the word [hide] to the column name or color it dark gray.
Having a hide/unhide checklist is the intuitive/obvious way to handle this, as noted by the other commenters. Please implement this function. Unhide all is complete overkill, and very inefficient way to show the columns. I may have 50 hidden columns tracking different metrics, etc.. and to unhide one of them the only option is to unhide all 50 and then re-hide the 49 that I want to remain hidden??? This is a great example of why there are comments online about Smartsheet making simple functions much harder than they should be.
Adding my thoughts here on Conditional Formatting. Not everyone likes to see "color coding"/conditional formatting on sheets. It would be a great feature to have Conditional Formatting settings by user just like filters. If I set it up only I can see it unless I check the box "Share Conditional Formatting".
We have a sheet with a contact list drop down. What we would like to do is have the user's first and last name with their email address added to this drop down list when the account is created and added to the Everyone group. Has anyone else looked at this option?
Within Salesforce Quip, there is a Smartsheet Integration. I think it was developed by Smartsheet. Problem: The integration doesn't have a selection for the new Board view. One may only select from Grid, Gantt, Card, and Calednar. See my capture below. Thanks for looking into this. -Marc
@Rich99 , it's the same. When you hide the column the only what Excel does is set the width of such column to zero. Two vertical lines shall indicate such column, was it hide or manually set to zero width. Unhide shall work in both cases. However, sometimes doesn't.
3a8082e126