-
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…
-
Transfer Row Automation to a sheet with a formula
I created an automation to transfer a row to another sheet when the ship date is triggered. When I test it and change the date the line item disappears but does not show on the selected the sheet. The sheet it is transferring to has a formula in 2 fields in which the transfer sheet does not have such as the Month Column…
-
Missing Source Data on Dashboard
I was just in my Dashboard and saw all of my charts and graphs. Now, when I log back-in, I am getting a Missing Source Data on my Dashboard. How can I recover?
-
How to get a countif formula to work when counting a range of a # value
I am trying to count the # of a certain # in a column. But it gives me either an error message (invalid data type) or a "0". I think I have to use countif and value somehow. TIA!