-
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.
-
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…
-
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…
-
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…
-
Table View Matching
I'm doing a column match in table view. Here's the results I got: When Source Sheet primary column is a calculation = No Match 2. When Source Sheet primary column is manually typed = Match Nothing else is different, is this a limitation that you can't match on a calculated field? The column types are both Text/Number.
-
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
-
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…