-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Merged: Find and Replace Function in Formulas
This discussion has been merged.
-
Collapse Columns
Similar to how rows can be indent or outdented and then collapsed/expanded I would like to see a similar feature for columns. i know I can hide columns but this would be different because It would be collapsed under a section.
-
Merged: Customizable Sheet View(s): save specific hierarchy layout
This discussion has been merged.
-
Expand All/Collapse All Default View Setting
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.
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
Mapping Data Mesh Sums from a Report to a Sheet
Hello, I've done a bit of preliminary research but haven't seen a similar issue discussed. While I know Data Mesh can bring data from a report to a sheet, is it possible to use it to bring over sums from a report into a sheet? I have a report which includes line-level financial data and have grouped that data by cost…
-
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…
-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
