-
Control Center Find/Replace to Edit Cross Sheet Reference?
Hello all, I was asked to delete a specific column in the CRAID Log template and all instances created through Control Center. In my Blueprint, I have a sheet that is used to store some meta data that feeds a larger 'master data' sheet. Unbeknownst to me, that column was referenced in a formula on the meta data sheet. Is…
-
Work around for duplicates to only show the most updated row
Hi, I have a list of names that were entered to the sheet more than once (but a different value in other columns). I have a helper column to identify which are the duplicates, but is there a way to show only one of the updated one in a report? Source Sheet Test 1 & Test 2 are duplicates, but I only need the newer enter to…
-
Removing Leading Zeroes Formula
I can't seem to find this anywhere, but how would you create a formula to remove leading zeroes in a helper column?
-
Sheet References from multiple sheets
Struggling with cross referencing multiple sheets. Sheet 1 - is auto-filled by a form from users in multiple areas. Sheet 2 - contains the standards for one area. Sheet 3 - needs to pull from sheet 1 (Task) and (Time) respective to area M1 & from sheet 2 The (Standard Time) relevant to Stanard Task I have been attempting…
-
Automation Not Responding to VLOOKUP
Hello Everyone, I have some data coming in from DataShuttle every morning to update status on pieces of work identified by 'OMNI #'s' (ex. OMNI123456). I have a formula in my sheet that looks at the OMNI number we put in then goes to the import from DataShuttle to find what the status was updated to that morning. Here is…
-
Count unique values based criteria
I want to count the unique values in my data, but based on a specific criteria. I have set up my data as above, and I want to get the unique count of Date and Handyman, but I would like to do it based on the value in the Month column. I know I can manually select the relevant rows for each month, but ideally if I can set…
-
Multiplication formula
Hello All, There is a question for multiplication formula. the one of cell is a formula, i need to use the price of this cell to multiply, but showed incorrect. Like below. Please help. Thanks in advanced. Zitong
-
Converstion of Date into Quarter & Year
Hello, I'd like to convert a date into a quarter as the following example illustrates: If the date is 07/10/2023, how do I get this converted into Q3 - 2023 in a new column I've created?
-
Status Formula
I need some help fine-tuning this formula. I need it to follow the following rules. Open to better options!!! It would need to be on a parent row. It will summarize the children's status. Rules: If all are 'Not Started' then the summary should show 'Not Started'. If all are 'Completed' then the summary should show…
-
Find Average Number if Criteria is Met
I need to determine the AVG number from a list of numbers if the Year and Week Number criteria are met. For example, if the Year is 2025 (Year Column) and the Week Number is 1 (Week Number Column), I need the average number of days in the FO Node Upgrades Duration column. I know that this formula =COUNTIFS({Year}, "2025",…
