-
Reversing WEEKNUMBER Function
Hi all, I have a few values corresponding to different dates, and I would like to group these dates by their respective weeks. What I am thinking of doing is using the WEEKNUMBER function to generate what week they are in, and then grouping them using this number. Additionally however, I would like to group them by the…
-
COUNTIFS for last seven days with date field and checkbox
Hi all, I have a tracking sheet 1) with a checkbox column (named [Doc processed]) to note when a document has been completely reviewed , and 2) a second column (named [Date processed]) that gets an automated date added when that box is ticked. I need to create a summary field that counts how many docs were completed in the…
-
Reference date above to carry on sequence when row moved
Hi Sorry to go into an old post but this is what I want, to look at the dates. I want to look at moving rows which have sequential dates based on planning. =WORKDAY([Online Date]248, 1, {Holidays Range 2}) I also want this to inherit from the date above to repopulate the sequence in order as shown Currently, if we move a…
-
RGYB Ball Formula
Hi there, Trying to create a formula where it uses date for red, yellow, green and then Complete checkbox for blue. Below is where I'm at, but it's not functioning. Any advice? =IF(Finish@row - 3 <TODAY(), "Red", IF(Finish@row - 10< TODAY(), "Yellow", IF(Finish@row - 15< TODAY(), "Green", IFAND(Complete@row = 1,"Blue"))))]
-
How can I count days since a row was created?
What makes this formula unparseable? =NETWORKDAYS (Created Date@row, TODAY(0)) I want a column that counts days since a row was created.
-
Formulas Stop Working and Then Work Fine When I Open the Sheet
I have several charts on a Dashboard that are pulling from multiple sheets. Within the sheets, the functions work with no problems at all. Suddenly the page seems to refresh and the charts shows "unable to Display" message. When I open the sheet the chart is pulling from, it briefly shows #Invalid Operation. Before I touch…
-
Countifs and Or
-
Show my "up next date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date so I know the "next upcoming due date" among a parent's children/sub-tasks. What…
-
I'm getting an "Invalid Data Type" error
Hello, I'm trying to count all rows (using a cross-sheet reference) which have either "Discovery Call - Scheduling" or "Discovery Call - Scheduled" in the Sales Status column but am getting an "Invalid Data Type" error. Thanks you.
-
And, Or, NOT(isblank) Formula help needed
Hi, I'm attempting to write a formula that would check a box in a specific column if the [De-prioritized?[check if yes]] column is checked OR the [Date Marked Complete] Column is NOT blank and [Date Marked Complete] column has a date more 30 or more days in the past. Below is what I came up with, but am receiving a…