-
How to setup an "If" with dates involved?
Pretty new to the SS scene. I am looking for assistance/guidance on how to create a formula to check the current date, and compare it to another date in a different column and if the difference is greater than XXX days have it provide a symbol. I have tried googling and have only found a bunch of functions:…
-
Stumped on a SUMIFS for Fiscal Year (FY)
Hello everyone, I am a bit stumped on a solution. I tend to not like to hardcode information into a formula. I was working through a solution to help manage a Business Development (BD) pipeline. With the help of the community, I figured out how to do a YTD. But then I was thinking that it didn't make sense to have the BD…
-
IF statement inside a COLLECT
Why do all of these formulas work: SUM(COLLECT({Value}, {Location}, Location@row)) SUM(COLLECT({Value}, {Location}, <>"")) SUM(COLLECT({Value}, {Location}, IF(index@row=1, "Boston", Location@row))) But this does not: SUM(COLLECT({Value}, {Location}, IF(index@row=1, <>"", Location@row))) I'm trying to understand this…
-
Counting Number of Boxes Checked in a Single Row
Hi all! I am wondering if there is a way to count the number of times a box has been checked in a single cell. For example, I have a row that shows the years that an employee participated in a program (2015-2022). You can select multiple because they can stay in this program for many years. Then I would want a formula to…
-
COUNTIFS CONTAINS & NOT FORMULA
Hi all, I'd like to know how I can modify this formula to make it work? Within row4 to row18, I want to count the number of "Complete" deliverables under Status Column for "Product Management" under Person Accountable Column. And the count needs to exclude the deliverables with a check-off under Inapplicable Column. How I…
-
Finding the last highest value, and subtracting from @row value
Hi, I have a sheet where CNC operators enter the hours the machine has worked each day, and i want to avoid them having to reset the time clock eacht time. I have been struggling with a formula that helps me achieve the following objective: Find the highest number of hours entered for the same machine on the current row…
-
Can I extract the month or year from a date column for a formula...
...without creating separate columns for Month and Year like in this screenshot where formula for Verbal Agreement Month is =MONTH([Date of Verbal Agreement]@row) and formula for Verbal Agreement Year is =YEAR([Date of Verbal Agreement]@row) Thank you!
-
Cross link Workflow
-
How can I link two sheets together?
Hi. I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications,…
-
COUNTIF showing "0" when referencing a column where cells have formula
Hello! Please help! First I have one sheet (Pre-Service) with several columns, three of them used here, the first two are dates, and the third is a calculation to determine the number of weeks between the two dates. I used (=(([Anticipated Graduation date]@row) - ([Pre-Service Class Start Date]@row)) / 7). So far so good.…