-
Cell Linking Multiple Cells with Control Center
I have two items that are provisioned in Control Center when a user submits a new project - one is a checklist and one is the project team list. In the checklist, the role for each task is linked to the team list (so a person can be marked the Project Manager in the team list and all applicable tasks in the checklist will…
-
Return multiple contacts based on department dropdown list.
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…
-
Anyone else experiencing EXTREME delays with cell linking?
I'm noticing SEVERE delays with cell linking lately. As in over 15 minutes before the cell populates. Our plan includes tech support, so I called yesterday. They said "up to 5 minutes is normal" I'm at over 15 minutes with no data being pulled down from the other sheet.
-
Whole Column Linking on a Primary Column?
I am trying to dynamically link 2 columns from 1 sheet (Sheet A to Sheet B) to another. I am currently using cell links from the whole column of Sheet A but the issue is that when new items get added to sheet A they don't pull over to Sheet B The values are getting added to the top of Sheet A and I would rather not change…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
Mode date related features
When a date is changed on an action, we would like for SS to be able to determine if the new date is Before or After the initial date. This would be a real game changer for tracking projects deliverables.
-
Issue with transcribing a reference formula for Add-On Rates
Hi, I'm having an issue with writing a reference formula for Add-On Rates. I've included pictures of the Reference Sheet and the Main Project Tracker here, with Client Name info redacted. The "Team Member Rate Sheet Pull" helper and "Project Rate Sheet Pull" helper columns both have formulas that work: Team Member:…
-
Dashboard Help- COUNTIFS, Checkboxes and Hierarchy
I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is measuring by Parent/child hierarchy with the formula =COUNT(ANCESTORS()) + 1 Thanks!
-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as the…