-
how to bring entire column to new report
I have master sheet where people update values daily basis. There is column of carrier contain lots of carrier some are repeating. I want to show all distinct carrier list to my report. I tired to build group on carrier but primary column making a mess.
-
How can I search another sheet for a name match within a certain date range?
I'm struggling to create a formula that will not only look for a name match from one sheet to another, but it will only return a match if the date on the row was within the past 6 months. For finding a name match between sheets, I've been utilizing the following formula: =IF(CONTAINS(Contractor@row, {Change and Offboarding…
-
Sheet Summary CountIf Help
Trying to pull a sheet summary of any budget over 60% of the cap, and keep receiving a Divide by Zero error. I can't tell why the error if occurring, but any help is appreciated. =COUNTIFS([Billing Type]:[Billing Type], "Hourly", [% Budget Spend]:[% Budget Spend], >60)
-
Help w/countif for blank fields
Hi team - I'm trying to create a nested COUNTIF function that returns either Not Started or In Progress in the Update Status column if any or all of the specific column rows are blank, otherwise show Complete. Update status column has Not Started, In Progress, Complete as drop-down menu options. I tried the following…
-
How to reference column name in formula
So I want to use a vlookup that compares a column name to pull information. Obviously if I were referencing a cell, I would type ColumnNameRow#. However, the column name does not have a row number? How do you reference it in formulas?
-
Creating a Survey Intake Sheet Summary from a Template
Hello, I downloaded the Template Set - Employee Pulse Check and need some guidance on customizing this Survey Intake Sheet Summary Report. I have added my questions in the Survey Intake Sheet and hid columns that we don't need. I didn't edit any formulas or delete anything from the sheet. However, when I open the Survey…
-
Different approvals
Hello All I have a question, i have a sheet and approval workflow is triggered when a new item is created. There are two approvals that are needed coming from two cell, and i want to see to overal Status of the approval. I am using formual: =IFERROR(IF(OR([BSS approval]@row = "Rejected" , [Function Head Decision]@row =…
-
How to make a COUNTIFS Formula work
Hello, I'm hoping someone might be able to help me make a COUNTIFS formula work. Some background... I've set up a sheet that aims to capture a team's availability of staff in any given month, should their be a major event occur. The staff would complete a form that asks for their name, contact details, job role and their…
-
End Date is auto-filled, how to stop?
Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter Start Date with the default value of the same day as Start Date. It is very inconvenient, I am…
-
Flagging a double booked room
Hi Guys I have a tracker that my team use to manage their daily tasks. However, due to COVID there can only be a specified number of people in a room at a certain time. Often rooms have been double booked, resulting in work being delayed. I want to highlight whether a room has been double booked on a specified date by an…