-
Blackout Date Template
Does anyone have a good blackout date template I could borrow? Something that is easy on the eye when glancing at it? Thanks...
-
IF statement with child/parent logic
The Problem: I need to have autonumber as a Unique Identifier for each row. When that row changes due to changing business requirements, I want to create a child row but it should not have a different Unique ID from the parent. It could either have the same Unique ID or no Unique ID, but if I have autonumber turned on then…
-
Jira Connected Sheet and Hierarchy re-arrangement
Hi- I have been doing some searching on the community and cannot find a clear reason or explanation as to how to to set up the "Optional: Define Row Groups" I cannot find any documentation or help videos on YouTube or the community that explains how this works. Here is a screenshot of my sample project Here is what each…
-
HELP with IF formula and cell reference
I would like to check cell [Actual Finish Date}4 for a date before executing =IF(ISBLANK([Planned Finish Date]4), 0, IF([Planned Finish Date]4 < TODAY(), 1, 0)) which sets a FLAG to true. If [Actual Finish Date}4 has a date then set FLAG to false. If there is no date then execute on the above formula.
-
Master Sheet - Exceeds Row Limit
I am struggling to figure out how to have a "master" listing of customers that can be referenced by various sheets via INDEX/MATCH cross sheet formulas when that list is too large. Here is my background: I have a master customer listing of 6200 customers. I use DataUploader to upload this into 3 sheets due to size…
-
Filter suddenly not working
Hi All, I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-1 NLOND_3709-2 -2 -1 -2 NLOND_5612-1 The filter looks for data that contain -1 and another filter looks for data that…
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Can I delete rows from Master sheet?
Hello, I have a Master sheet, into which information comes every day via a form. I also have a Wrap Up sheet which pulls specific data from the Master and manipulates them via a formula into a number I need to display. For example, the form populates the Master Sheet with the number of patients on a unit at midnight, the…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…
-
Roll Up Sheet needs daily "activation" to work
Hello, I have a Master Sheet and a Roll Up sheet based on the Master. The Roll Up uses a lot of formulas, including the "TODAY()" function. Apparently, the Roll Up will NOT refresh to reflect the data that came into the Master unless I physically go in to the Roll Up and "activate" it by scrolling around in it and…
