-
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.
-
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…