-
Date Dependency
Hi, Our ERP system exports tasks and the materials needed for those tasks with the same task ID number. We schedule based on the actual task and predicted duration. Is there a way to automatically assign the same start date to the materials needed for the tasks based on the scheduling of the actual task? Screenshot…
-
Nested COUNTIF formula
Hi! I am hoping someone can help me solve this formula. What I am trying to do is keep a running total of hours of vacation used. For example, If Joe wants to take an 8 hour vacation he will go to the dates and type in "V8" (Vacation, 8 hours) or 4 hours would be "V4".ETC. When this is entered I want those hours to be…
-
Most Recent Date
Hi everyone... I've been struggling with how to do the right formula here and would love if anyone could help. I have a form which people are to fill out twice a month to do a temperature check on their progress. The data will have the date, name, etc., then their "mood" (a dropdown list), and each entry will be a separate…
-
finding items past due
This is a formula to find out how many tasks Jane Doe hasn't marked complete in the last 7 days. It's not producing the correct number when I run it by a filter on the original dataset. Any insights on how to make it more simplified? COUNTIFS({Project List Range 3}, FIND("Jane Doe", @cell) > 0, {Project List Range 4},…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
help with formula
Hello, I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with. What I want to do is to check/compare email addresses. The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entry is the same like [Email] entry.…
-
IF Planned Date is Still blank leave RGB Status Column Blank
Hi, If you could please assist with the formula below? The formula works perfect, except for when no date is entered in the Planned start date. Currently when no date is entered in the Planned start column the RGB ball stays "Red", and i would like it to show "". Current formula: =IF([Kick-Off Meeting Actual Finish]1 <>…
-
MONTH and COLLECT
Is there a way to use the MONTH function with COLLECT to, say, find the highest date in a column that is in the month of October? Basically, to simplify a formula like this: =MAX(COLLECT([Due Date]:[Due Date], [Due Date]:[Due Date], >=DATE(2018, 10, 1), [Due Date]:[Due Date], <=DATE(2018, 10, 31))) to something like this:…
-
count one column based on a different filtered column
Hello, I have a list of staff names in one column and another column with task statuses (Not Started, In Progress, Complete). I'd like to find how many In Progress and Not Started tasks each staff member has. I've tried COUNTIF and COUNTIFS but can't quite get the formula right. All of the examples I'm finding are looking…
-
RYG symbols return date in different column
Okay so I'm almost done with my project but I ran into a snag and needed some advice. Basically what I'm trying to do is that when I pick the Green symbol todays date is input into the date column, Yellow = todays date in MISC column and leaves the previous date in the Date column. I've programmed for the green but every…