This discussion has been merged.
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
A function that gives you the row number of a cell as a number without using a workaround.
Would like to have the option to set the default view for a sheet with many parent/children rows, so that each time the sheet opened that default view would be shown. In other words, I'd love to have the default view at each opening of the sheet to show only the parent rows without having to choose collapse each time.
I know this topic has been addressed previously and was resolved but is now happening again. Is there a way to disable or remove the workspace panel from auto-opening each time you open a sheet? It's extremely frustrating!
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
This has just started happening in our company and is quite annoying for our folks. Is there a way to stop it from opening every time our employees open a dashboard, sheet or report? It is just extra clicks all day long they don't need to be making!
Hi, I'm trying to highlight all tasks with an "e" in the duration column, since "e" overrides all weekends and holidays I need to be mindful as to not forget an "e" somewhere when the schedule changes. The Conditional Formatting does not work to highlight it by just saying "if duration contains 'e' then apply this…