-
How do I score out a survey and have it populate in another column?
Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
-
Compare submissions
Hello! I would like to compare submission such that older submissions from same field "Name" are moved to different sheet. I can add a helper column called "Older" and would like to either populate the older rows with the word "Older," and number to signify it is older, or a simple yes/no dropdown. I currently have a…
-
Sheet Summary - same sheet VLOOKUP with TODAY()
Hi, My Column Headers are: Date, Total Opened Cases, Total Closed Cases, Total Backlog. I am attempting, and failing, to use the following variations of a VLOOKUP formula. Can someone help?? =VLOOKUP(TODAY(), {Date}:{Total Backlog}, 4, false) = #UNPARSEABLE =VLOOKUP(TODAY(), {Date:Total Backlog}, 4, false) = #INVALID REF…
-
Please Add a Sum Product Formula
Please add a sum product formula to improve ease of calculations without workarounds.
-
Nested IF/AND/OR
I'm modifying a formula used for status tracking and I'm running into an unparseable error that I'm having problems resolving. I want to make the status red (stop sign) if the status is "in progress" or "not started" when the "at risk" column is checked. My understanding is that the formula will look for the first true…
-
Fiscal Year Starts in February sometimes end of January
Our fiscal years (FY), quarters (Q) and work weeks (WW) are giving me heartburn. I realize I need to create a table in order to capture each fiscal year. However, when putting in the formulas so far I am seeing issues with my Work Weeks and Fiscal Year columns. Part one (1) of my heartburn. For example, my work week is…
-
Sheet Summary COUNTIF error when summarising formula driven cells.
Hi all, I'm creating a sheet summary report with the intention of summarising when passed tasks were completed relative to planned completion data i.e. early, on time, late. To do this, I'm using an =IF formula (which works) to define how to label tasks in my "Completion" column based on whether the 'Actual Completion…
-
Calculating Avg Workdays w/ Conditions
Hello! I'm currently trying to calculate the average amount of workdays it takes for each person to complete a specific request on a metrics sheet from a parent sheet. For example: How long does it take me on average to complete a FOIA request? How long does it take me on average complete a litigation request? Request Type…
-
How can I show a colored health dot based on the other colored dots in the same column?
I am trying to have a cell show a colored health dot based on the other dots in the same column. This cell basically shows red if there any red dots, yellow if there are no red dots and at least one yellow, green if there are no reds or yellows, and blue if all other dots are blue. This cell called out should have a red…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
