-
Formula in Date Column
Hello, I am trying to get a date value from another sheet in a date column using Index(Collect(.......),1) function. However, every time I add a formula in date column it converts to text by adding a ' sign. For Example: Sheet1 has following columns: Location Project Start Date End Date ... .. .. .. I want to move Start…
-
checked box formula to use for dashboard?
I'm trying to create chart that will show cleared vs uncleared roles. I am trying to apply a countif formula for my sheet but it's not showing the counts. I am using the formula below. Am I doing something wrong Please help! Thanks, Nyasha
-
Pull the first non-blank value from a range of cells in a row
Hello, I have a series of columns that will be filled with a project name (from a dropdown) depending on which column is filled out from my form. I want to have a sort of master list column, that will display the project name for any given row (since otherwise, the project name will be in different columns depending on…
-
How to sort values using formulas? INDEX(COLLECT, COLLECT, VLOOKUP?
Hi, I am trying to sort the values (Machines) based on the "OEE Current Month Column" and referred it to the "OEE_C" (used Large formula). I have used 3 formulas to get the CM Machines sorted based on the OEE_C, first I have used VLOOKUP but when it reached the same values it stop showing data or leave it blank. 2nd, I…
-
# No Match errors with INDEX/MATCH formula
Dear Community I am having the hardest time debugging some #NO MATCH errors with my INDEX/MATCH formula. I have triple checked and can’t find any reason for things not to match. The rows right above and below work fine. I am pulling in the percent complete into a summary view sheet. I am matching on the site name,…
-
Formula to add check to checkbox based on several other checkboxes
Hi all, I am trying to create a formula that adds a check to a checkbox once a check has been added to 5 other checkbox fields in the same row. The other checkboxes are also automated and are checked based on other criteria (however, I don't think that matters here). Below is what I have so far, basically if ALL of these…
-
Countif value matching from multiselect cell
Please help, i have 2 sheets. One sheet contains week no. i.e. the week in which a member is absent. I wanted to count week numbers from that column only if week number is mentioned in other sheet under (multi select cell). Ì used this COUNTIFS({Team Vacation Planner Range 2}, [Assigned To]@row, {Team Vacation Planner…
-
Vlookup on reports
Hi I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup? Thanks
-
Simple Division formula resulting in error and should not be
I am having an issue with a simple averaging formula providing an incorrect outcome. In the example above the dollar amount in the DATA column is a result of a SIMIF formula. Additionally the results in Column4 are the results of a COUNTIFS formula. In Column 6 is a simple average formula that I wrapped in an if statement.…
-
Auto-assign # based on parent or child (sub-item)
I looking for a formula to auto-assign a number based on the parent/child level. For example, first level parent would be auto-assigned zero (0). Any sub-items would then be 1, 2, 3, etc. based on what level the item is listed under the parent. I've provided an example of how this would look, but I've manually entered in…