-
Merged: Let folders be folders!
This discussion has been merged.
-
How to edit Sheets and Dashboards as Admin
Hi all, I'm an unlicensed admin and my supervisor is a licensed admin. My other supervisor is on leave and is listed as the "Owner" on most sheets and dashboards. Neither of us are able to make any edits to these pages nor can either of us make new dashboards or sheets. I used to be able to make edits with no problem until…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
Copying a cell with an auto number from one sheet to another overwrites existing auto numbers
Hello, I'm using two intake sheets for different project types. Each intake sheet is populated by an idea submission form and the entries receive a unique number with an Auto Number column. So far so good. Situations come up where a project of type A needs to be moved to type B. We do this with a checkbox, which when…
-
Can you uses forms to populate fields in existing rows instead of creating an entirely new row?
Hi all, hope this message finds you well. I'm building a sheet with the purpose of being a 'One stop shop' between our organisation and external parties. So far, I've built a mastersheet with a form for our internal team and two separate sheets with their own forms for the external individuals involved. The aim is for our…
-
Creating a formula for metrics sheet with multi-selection dropdown
Hi all, I am creating a metrics sheet, and am having trouble creating a formula to count how many cells of a specific variable (call it "Zone") has multiple selections. I've already counted the ones where only one zone is selected but, but am missing the counts for those remaining with multiple zones selected (can call…
-
How to create a flag column that identifies a scheduling conflict
I am trying to create a checkbox column that gets checked when the conditions of a formula are met. Essentially, I am trying to flag a row if someone is assigned to that row who already has an assignment for that same date AND if the start and end times overlap. Example: Interpreter= John; Date= 6/1/2025; Start Time= 8:00…
-
Calcs for a multiple conditions
Hi, I want to use this formula: =COUNTIFS({1. Main Tracker Range 1}, "Pending", {1. Main Tracker Range 3}, TODAY(-1)) + COUNTIFS({1. Main Tracker Range 1}, "Confirmed", {1. Main Tracker Range 3}, TODAY(-1)) Which has two different conditions, this worked in the Summary tab. When I am referencing it is not coming out. In…
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea