-
I want to use a date in the parent row in a formula to generate another date (in the child row).
Partial data (some columns are hidden) I would like to use the IT Installation Date of the parent, to populate the Due Date of the Server is up in Store row. Then, I would like to use a different column (called SO Date) to calculate the 3 weeks to Soft Open, 1 Week to Soft Open, and 1 Day to Soft Open Due dates. I tried…
-
If/And Statement
Hey again, I am stuck with something a bit beyond my current skills. I need to write a formula that I believe will be an If/And Formula. The formula needs to populate the Case Status cell. If the the Tentative Return Date column is blank, the Case Status Cell should be "N/A", if the Tentative Return Date is within 10 Days…
-
Why am I no longer able to see one of my sheets to copy rows to?
I have a Automation workflow set up to copy rows from one sheet (Sheet A) to another (Sheet B), both of which I am an admin for, but all of a sudden, the automation is no longer working and I cannot see sheet B as an option to copy rows to. The issue seems to be with the sheet A, as in other sheets I own (Sheet C), I am…
-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
-
Counting Distinct ID that excludes certain business titles and includes Open Status only
Hi can someone help me out with this one, =COUNTIFS(DISTINCT({Requisition ID}, {Business Title}, NOT(OR(@cell <> "MSS", @cell <> "Sales Engineering")))) I want to return the count of distinct req IDs, that are open, but exclude business titles that contain "MSS" or "Sales Engineering". I have tried a few things but no luck
-
How match a value from a second sheet to a correlated date
I have two sheets, a primary sheet and a second sheet I'm using as a metric sheet. Sheet 1 (Primary sheet) Sheet 2 (Metric sheet) Some background. The first sheet uses a formula in the "Next Action Item Column" =IF([Year of Project]@row = "1st year", MIN(COLLECT({Key Dates (AC)}, {Key Dates (AC)}, ISDATE(@cell), {Key Dates…
-
SUMIFS over dollar amount threshold
Hi, I currently have a working formula that totals up amount of money for a specific company =SUMIFS({Cost 2021}, {Subsidiary 2021}, Subsidiary@row) I now need that formula to be if the cost in column Cost 2021 is greater than 5,000 for that company. I'm struggling with how to get that into the formula. I have gotten all…
-
Help setting up formula IF
Hi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH(DATE@row) = 1, "January", IF(MONTH(DATE@row) = 2, "February"....) Although we have a cut off date which is the 25th of every month. All projects due after this date should be pushed to the…
-
RAG Looking at Two Dates
SS Community, I am hoping you can help with a formula problem I am trying to solve. I have a RAG column that is currently looking at a due date and based on some criteria it will return a RAG value. What I am trying to add to the formula when there is a revised due date added to look at that column instead and return the…
-
Formula Help
HI, I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "Green".