-
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.
-
Function Question
If a cell is check marked "✓" then I want a cell next to it to show the value of another cell. Then I want all subsequent cells underneath to run a value of that cell plus the value of the previous cell(s) only when checked. How would I create the formula for that please? For example if N3 is "✓" then M3 equals value of C3…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Automated Workflow Notifications
Hi everyone, Is anyone having issues with notifications? Since yesterday, I've had a few automated workflows that, when triggered, are not sending the email notification or even alerting the user via the Notification bell.
-
Admin Center User Auto-Save Default setting Control
When a new account is created, auto-save is automatically turned on. In our company, we would like to disable auto-save by default. However, there is no way to set the default setting for this in the Admin Center. Many of our users have many Tabs open and use multi-screens. We want to avoid them accidentally overwriting…
