-
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…
-
How to create a source sheet that automatically updates other sheets if data is removed?
Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added…
-
IF Formula
Hello, Not sure how to create column formula for the following criteria utilizing RYGB color formatting: • 0-29% red • 30-49% yellow • 50-99% green • 100% blue