-
System telling that I've reached the sheets limit for my plan when I have't used any of them yet
I am asked to Upgrade because I've "reached the sheets limit for my plan". I have a trial plan and I have NOT use any sheet yet. My Workspace is empty.
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Requirement Document and Auto-numbering
Hi all, I'm trying to solve for a few things with a Business Requirements sheet. Auto-numbering of High Level and Detailed Requirements Association of High Level Requirements to Detailed Requirements Adds, Deletes, Changes. Example - A Detailed Requirement could be moved from one High Level Requirement to another. Example:…
-
Contact Datatype - Data Shuttle Import Function - Column Property Toggle Question
Hello, I have seen a few posts that have a manual workaround for this problem, but they are all a few years old, so I thought it best to start a new thread. I use data shuttle to import (First Name, Last Name, Email Address) to a sheet I can create a new column "Contact" using the Contact Datatype I can populate "Contact…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
-
Assign in rotation
I have a sheet, and need to add an "assign to column", and would like to auto assign each line to one of four people in a rotation. So, submission one goes to the first name, submission 2 goes to the second, submission 3 goes to the third, submission 4 goes to the fourth, and then the cycle repeats with submission 5 going…
-
Edit recurring report email
I set up a report to get emailed to a few people once a month. I would like to edit who is receiving this report, but I can't find the report schedule. I found a few posts about this but clicking on File—>Send as Attachment just allows me to set up a new schedule. Can anyone help?
-
Filter using Current User not showing all data
A filter I've been using is suddenly acting oddly. I have a list of associates with Year, Manager, and 1-over Manager columns. My filter looks for Where Manager is one of Current User OR 1-over Manager is one of Current User. The result shows correctly except it only shows the results for 2023 and 2024, not 2025 or 2026.…
-
Sheet fields missing from form creation.
I have an index doc sheet with 4 columns of information to pull in onto a master sheet. I then have other fields on the master sheet which I need filled out by using a form. When I go to the form creation, it only lists 1 of my fields from the index doc sheet and master sheet to select for the form. Why is that and why…