-
I am trying to return a value based on a couple of criteria. I'm using the index/collect method.
I have 2 sheets. Sheet 1 has a list of names. Sheet 2 has a list of locations, dates, and who is there across 6 columns. My goal is to have sheet 1 list where these people are currently located. Sheet 1: Sheet 2: Formula for "Current Site" field on Sheet 1: =index(collect({Sheet 2-Column1},{Sheet 2-Column30},"Yes",{Sheet…
-
Weekday Function that displays last 7 days
Hello, I currently have a date column with =Today() that tracks the current last 7 days plus the current day, this is paired to data that occurred on the corresponding day in order to display metrics on a dashboard. As you can see there are zeros on the 25th and 26th as it was a weekend. I am trying to utilize the =Weekday…
-
COUNTIFS
Can anyone help me figure this out. I'm trying to add a COUNTIFS to my sheet and I'm getting an Unparseable error. =COUNTIFS({Sales Ops Support Ticket Tracking with Form}, [Group Name/Portfolio]:[Group Name/Portfolio], "Gift & Home", [Salesforce Item]:[Salesforce Item], Account Owner Mass Update)
-
How do I make a column formula that automatically checks the box if another column contains 1.
I am trying to make a checkbox column automatically check its box if the column1 contains 1. It may be equal to one but in some cases, it could be 1 high or 1 low. How can I check to see if the cell in column 1 of the same row contains 1. I have tried =CONTAINS(1, column1@row), but the boxes aren't checking.
-
Checking a box using an IF/OR statement
Hi, I am trying to check a box if either of these statements are true, but I'm getting an Invalid Data Type error. The "Operational" statuses are from a drop down. Data Upload is "Operational" OR Retail Survey is "Operational" This is what I have: =IF(OR([Data Upload Status]:[Data Upload Status], ="Operational", [Retail…
-
How to Find the Furthest Status
I have 2 sheets. 1 with all my active job orders, 1 with all active job applications. I want to create a column on the job report to represent the furthest active application Example I have a job called "Accountant" on the Job Order sheet. The ID# is 1234 On the application report there are five applications with a Job ID…
-
Did the COUNT formula change to include blank?
I want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes. Does anyone have any idea why this changed?
-
Creating a dashboard from a sheet with multiple data types
Hey all, attached is a screenshot of a sheet I am trying to create a dashboard with. The issue I am having is creating a chart/view to show completion of a year review meeting by student. The 'Complete?' check box is what we are using to mark completion of the meeting. When I try and make a dashboard from this sheet and…
-
Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all, I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains…
-
Creating a Booking System with a Time Component
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…
