-
% of check boxes
I am trying to make the row 20 box thats selected to display a % of the check boxes in rows 2-19 that are selected. I have tried a couple formulas none work. =COUNTIF([Complete]2:[Complete]19, 1) / COUNT([Complete]2:[Complete]19) =COUNTIF([Complete]2:[Complete]19, "true") / COUNT([Complete]2:[Complete]19)
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…
-
Row Menu "Send" Option Not Working
A colleague of mine and I used to use the row menu "send" option with years of success. It would email the row data to an email address of our choosing, but it no longer works. A couple of new interns we hired use the option with 100% success. I have tried all of the solutions found online and have not found a solution.…
-
Counting items created within a certain date range
I am trying to create a formula that counts the number of rows that meet a certain criteria. In this instance, i have a date field called "Created". I want to know how many rows were created in the year 2025.. Any thoughts on how i could accomplish this? I appreciate it.
-
Embeding forms into a dashboard that is part of a Control Center Template Folder
Hi, I'm finding difficulties when trying to embed a form into a dashboard that is part of a template folder for control center. Due to the fact that this form is embeded through a link, the form keeps it's original destination sheet when a project gets provisioned and the new dashboard gets created. In other words,…
-
How do I fix contact names not appearing in the cells of a sheet?
When selecting a contact from the dropdown list in a 'Contact list' type column (used to assign leads for tasks), only the email address appears in the cell when a contact is selected, but in the address book the name + surname and email address is listed for each person. How can this be fixed? Thanks
-
Control Center/BluePrint and Hyperlinks not working
I am using control center / Blueprint to provision new projects. For clarification, we have a set of 8 templates that whenever we start a new project, the Control Center/BluePrint process creates a new project folder, copies in the templates, adds rows to 2 other sheets and establishes the links from our project folder’s…
-
Certain settings get lost on copying sheets
Hi all! While Control Center is not available in my organization, my solution is to mantain a Project Template (with its own sheets, reports, dashboards, etc.) that I copy to a new folder every time we have a new project. Unfortunately I recently noticed that some settings, specifically Gannt Chart timeline options…
-
Holidays for Project Schedules when using Control Center
To give a little background…. We use Control Center and our project managers are primarily set up as Editors, as the Admin permissions are more than is needed. We have a handful of Admins. The issue: Since our project managers span the globe, holidays are numerous and various. We don't want to add global holidays to the…
-
Network Diagram (Process Flow) View for Sheets
Develop a new view for Sheets that displays connected tasks as a network or process flow diagram. Once you have identified the activities and their dependencies, you can visualize the critical path analysis chart (CPA), known as the network diagram. The network diagram is a visual representation of the order of your…