-
Date formula
Hi. I'm not sure how to go about this. I have a list that have SO Dates that are all different including the year. I plan is to send an automated reminder every 3 months from the SO DATE starting now. For example, I have an SO date of 08/06/23. Based on this, a reminder would have gone out on 11/6/2023 (which is the past).…
-
Can I register blank cells during a nested IF conditional?
Hi, I have a question regarding a nested IF conditional that counts the next Friday after a date. What I'm attempting to do is to leave the cell blank if the captured date is blank. CONTEXT: My form has a column for manual input ([Actual Date of Publishing]) that I translate into the Friday following that date ([End of…
-
Vlookup table array with strings
Trying to do get value from another sheet that contains commas and spaces but the Index formula does not work, do you have any other suggestion?
-
Cross sheet reference names being scrambled?
I'm building some formulas to reference other sheets, and the names are getting scrambled when I reference various sheets in my build. For example, I'm setting up a summary sheet pointing to several other sheets. Sheet I'm referencing is Las Vegas (Support). When I click on the sheet to reference it, it grabs another sheet…
-
Return a specific value if between a range
I have a sheet in which several questions are asked, and depending on the answers then different scores are returned. There are seven questions, and I sum those in a column called [Imposed Risk Score]. From that total, I need it to report back a risk tolerance if the score falls between a range. 0-20: Conservative 21-40:…
-
#NO MATCH in Index/Match for Grandparent Row
I have a typical hierarchical project plan sheet with the project name on Row 1 and every other row indented under it to various levels. The Setup: Column: "TaskCounter". An Auto-number column with no Prefixes or Suffixes. Column: "TaskID". Column Formula: =MATCH(TaskCounter@row, TaskCounter:TaskCounter, 0) Column:…
-
Need help with the correct formula excluding "On Hold" items
I have a SS Sheet with the "Task Name", "Assigned To" and "Status". Please see all the Status below, (New, In Progress, Awaiting Approval, In Revision, Approved, Complete, On Hold, & Not Started) I am currently using this formula to count the number of Tasks for each person on my team: =COUNTIF([Assigned To]:[Assigned To],…
-
Formula to transfer data to a blank sheet
Hi! I am trying to figure out a formula to transfer data from one sheet to another. The old sheet has a "Supplier" name on it. Basically, I want that same name to appear in the new sheet. There is no unique identifier as the new sheet is blank. I'm not sure how to write it out though. Basically, if the "supplier" cell is…
-
Hello everyone, Novice formula help needed.
I have a column named % Probability 7-day close that shows the percentage probability of closing the amount listed in the Forecast Amount column. I'm in need of a formula that can capture every time 25% is listed and sum the totals from the Forecast Amount column, so I have an overall total of every cell tagged as having a…
-
IF AND Formulas for multiple answers
Hi, i'm looking to have a score generated if one or more criteria are met. Currently, i have =IF(CONTAINS("Gait Balance", [Why did they not pass Gait?]@row), IF(AND([Why did they not pass Gait?]@row <> "Gait Symmetry", [Why did they not pass Gait?]3 <> "60"), IF(AND([Why did they not pass Gait?]@row <> "Gait Power", [Why…