-
IF function 100% Complete
Hello, I'm trying to figure out using a symbol column type, once the visual symbol of a checkmark is selected, to then have the % complete column populate "100%". I can't seem to figure out the correct function to apply to all cells under the symbol column to automate this action. Any help on accomplishing this is greatly…
-
Count Checked boxes from another sheet
Hi - I've seen this question a few times, but I am still not able to get this to work. I have a Metrics page that I am rolling totals up to so I can display a donut chart of projects per GEO. This has worked, up until now, because I have a single column as a drop-down to show these metrics. =COUNTIF({Geos}, Metric9)...I…
-
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
-
Countif, isdate, weeknumber
Hello, I'm trying to write a formula that will count rows containing a date that is part of the current work week. The date column has non date values in a few cells which seems to be throwing off my formula. This is what I have so far; =Countif([Due Date]:[Due Date], AND(isdate(@cell),…
-
COUNTIFS with multiple conditions
Hi there- I have this formula built to count the number of projects completed within a certain date range: =COUNTIFS({Completion Date}, >DATE(2017, 7, 1) <= DATE(2018, 6, 30)) However, there are five different stages of a project: Completed, Under Construction, Approved, Under Investigation, and Cancelled. I would like to…
-
Using Trend Arrows
I have a formula which works out the Net Days since an event occurred. I have the following: [Event Type], [Days Since Last Event], [Day Before], [Trend] The [Event Type] is the event I am searching for the number of days since the last one occurred. The Number of days appears in [Days Since Last Event], is a formula which…
-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
Direction symbol in formula
I would like to use the direction symbol (up,down,sideways) in a formula if =IF([ISS-Backlog]1 < [ISS-Backlog]2,“Down”) but it is not working. Any help would be greatly appreciated
-
Count Ifs Dates in the future with multiple conditions
I am trying to create a formula will return a count of dates 21 days from the current date, but also sorted by an Assigned persons name and multiple statuses of the request. Here is a formula that I have so far: =COUNTIFS([Assigned To]:[Assigned To], "Name", [Status]:[Status], "Scheduled", [Start Date]:[Start Date],…
-
Formulas COUNTIF between to numbers
Hello, I am new to the Community. I am having such trouble with designing a formula that will use two past due days for which to count. Here is what I have for the 30 to 59 days count of past dues. =COUNTIF({Audit CAP Summary Range 1}, ">=30") + COUNTIF({Audit CAP Summary Range 1}, "<= 59") It returns a number but the…
