-
Enable multiple views of same sheet within a workspace
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view version of that sheet. For my use case, the main sheet would live as a grid, then a calendar copy could be made that is locked…
-
Finding the earliest date from Children based on the status in other column
Hi all, I'm trying to find the earliest (Min) date from children based on the value in a different column. So if the value in Asset Status column is not "Completed", "Cancelled" or "On Hold", then consider those children and then find the earliest date(min) from them. The column where I'm trying to find the earliest date…
-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Where has Create a new sheet gone??
Hi The option to create a new sheet just a plain sheet has gone from the Home screen. Now all you have is "Solutions" or Grid, Form, Dashboard etc when I do not want anything with anything pre filled just a plain old sheet I can create myself. Why has this disappeared and why is it so hard to find out how to do the…
-
Progress with children rows
Hello all I have a tracking sheet for payments under several Purchase Orders (POs). Each PO can have different numbers of milestone payments—anywhere from one to ten or more—until the PO is completely paid. For each milestone, I need to mark it as 100% and then i need send invoice. The parent row should then show the…
-
Any ideas on an easy way to capture data on a rolling monthly basis and show on a dashboard
We are capturing different types of statistics for multiple different subject areas every month and need to: a) easily get people to update the data b) easily show it on a Dashboard I've tried multiple different ways of sheet design but I keep coming up again blocks - ie either data can't be shown in a graph or the…
-
Can you hide the toolbar on a sheet embedded in a dashboard?
Hello! I have a dashboard that has a sheet embedded on it. I'm aiming to make it accessible to anyone with the link to it. There is one cell on the sheet that can be changed from a dropdown column and this will update all of the data on the sheet. I'd love to hide the toolbar and icons along the side so there is no…
-
Cannot find sheet for copy automation
I have three sheets that I am trying to get to copy to each other for bidding. I have made this automation for multiple other projects in the past. When I go to find the sheet that I am trying to copy to, it is saying no results found. I am an admin on all sheets that I am trying to use. I have copied and pasted the entire…
-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
Formula to use in the summary field for the number of rows within a specific column
For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.
