-
Counting prior month data
Hello, I'm trying to report on prior month data points within a Dashboard I created. I've built a metric sheet off a "master" sheet. I've attached a screen shot of the metric sheet and a screen shot of the master sheet columns. Here is the formula I've been using to capture metrics - it needs to be changed to capture prior…
-
Changing a cell based on text in two different cells, nested IF/AND/OR formula not working
Hello! I'm trying to change the text in a cell based on answers in two separate cells. I basically need approval from two separate people in order for a request to be approved and if one of them denies the request I need the status row to show "denied". The formula below works for this except in the case where the current…
-
How can a calculate a due date based on weeks?
I would like to calculate a due date that is 4 weeks before a launch date. The below formula helps me calculate based on days, but I would like the due date to be 4 weeks before the launch date. =[Launch Date]@row - 28
-
Formula Help
Is there a formula to pull the first letter of cell contents? I'm wanting to populate the "Subcategory" column automatically instead of manually Thanks!
-
Can I use a formula in an If Statement?
I would like to insert a formula based on the selection "YES or NO" from another field. When trying this similar to other if statements i am receiving #UNPARSEABLE error. =IF([Mgmt Cost Needed]@row = “YES”, “=[SubTotal]@row * 0.1”, IF([Mgmt Cost Needed]@row = “NO”, “0”)) I know i could probably achieve this through an…
-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
-
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.