-
"Equal" cells
Hello Community, I have a regular project plan with several tasks, milestones etc. I was thinking of tiding it up by creating a collapsible section in the very beginning which will contain only the milestones. My idea was to use the simple "=" function so what I did was to simply clink on the cell in the Milestones section…
-
COUNTIF in Sheet Summary counting things that are not there
I am a formula novice and I am trying to count the number of instances certain criteria show up in a column. I noticed that it is counting extra things. For example, I know that it should add up to 6, but it is counting 3 extra things that are not there and the result I am getting is 9. Is this the right formula to use for…
-
Formula not populating certain rows
Hi everyone, I'm seeing an issue where I have a particular formula that moves a date to the nearest business day if the original date lands on a weekend. However, when I drag the formula down the column, it will not populate certain cells. (This is actually apparent across the entire row). Would you know how to solve this?
-
How to provide a checklist as a column in a form
Scenario: I want to make a form which is basically a guided walkthrough for customers to find out what they need to submit in order to be onboarded (Follow a series of conditionally-linked questions and at the end it will tell you what documents you need to submit in order to have the optimal onboarding experience) I'm a…
-
How to perform trend analysis on symbols
I have a sheet where I have two columns that show status (current and previous). These are represented by the colored dots (Red, Yellow, Green, Gray). I am trying to show tend on these status items with the following logic: =IF([Trend - Last Report status]1 = [Overall Status]1, "Sideways", IF([Trend - Last Report status]1…
-
How to add Dates to formula using TODAY(+7), etc.?
So I have several formulas calculating what date range a date is in...two weeks out, three weeks out, etc. =COUNTIFS([Calc if Done]@row, =0, [End Date]@row, AND(@cell > TODAY(+7), @cell <= TODAY(+14))) This give me a 1 or 0 result so I can count them, great! How can I change the formula so that I know what the DATES are…
-
Filter data on dashboard report
Hello! I have a report listing application statuses (approved, in process, declined) and agreement statuses (executed, in process, canceled) as a widget on my dashboard, and one of team members would like the ability filter by status. Is this something possible to do?
-
Index/Match IF certain year
Hi, I am trying to populate a separate sheet with the Projected Fees by year. For example, I would like to populate a 2020 column with the Projected Fees from 2020, matched to the appropriate Client. I have tried different versions of INDEX/MATCH but not working. I would like to INDEX the Projected Fee and the Year (2020)…
-
SUMIF formula for Summary reporting
Hi all, I am trying to create a sheet summary that shows totals for test results ("Failed", "Passed", "Retested", Pending"). I'm using the formula =SUMIF(Results:Results, @cell = "Pass") to pull the sum of tests passed under a "Results" Column, but this returning 0. :( I'm sure I'm missing something simple! Any tips?
-
Help with date formula's
I am creating a tracker that will keep track of vacation days, and the number of days an employee gets each year depends on how long they have been an employee. The days are earned each year on their anniversary. I have almost everything working with the exception of 1 thing. Let's say I have an employee that started…