-
Formula
Hello again, I need help with how to set up a formula for my dashboard. How do I create a formula that tells me how many Task and CAR's were issued per month? Please advise, thanks!
-
How do I show parents when filtering on tasks
I am filtering specific tasks based on resource, sub-system, Function etc. The filters are working fine, however I would like to see the associated parent tasks. So if tasks from level 2, 3, 4, ... are shown, I want to see their parent tasks shown up to level 1 or 0. Similar to how MS Project does.
-
how to set the timestamp in a cell if another cell (status) has changed
Hi all, cell "status" is set to "open", "work" and than "finished". I would like to set cells "open status date", "work status date", "finished status date" with the timestamp of the change of "status". How could this be done? Workflow is not able to set the value of a cell :-(. Thank you
-
Average Formula not Ignoring Blanks
Hello! I am having problems with the below formula (its a big one). I am trying to avoid creating 9 helper columns if possible. The below formula is including blank cells as 0s when averaging. I have tried a variety of combinations of OR, <>0, etc and cannot find a way to skip the blanks. Some of what I have tried will…
-
Nested If formula help
Below is the formula I am attempting to use. It works perfectly if I my Auto Pay row is No or when the due date has not yet arrived but it doesn't put in the amount in the due row if the date has arrived. What do I have incorrect. =IF([Auto Pay]@row = "yes", IF([Due Date]@row <= TODAY(), Due@row, 0), SUMIFS({Amt Pd}, {Bill…
-
Count If for Workdays
Hello, I have a sheet that has a column with a bunch of different dates on it. I'd like to easily be able to visualize how many of those dates fall within the 1st week of the month, 2nd, 3rd, etc. I'd like to organize it by actual workdays rather than dates. Any suggestions for how to display that data? One thought is to…
-
Question Regarding Multiple Forms.
Hello All, Is there a way to link multiple forms to 1 row? I assume it would need assigned number to reference For example (New Entry into Row 1) Form # 1 would require data inputted in columns 1,2,&3 - populates in row # 1 when submitted ( Work Order Number generated automatically ) Form # 2 would require the work order…
-
Workday and VLook up
Hello, This formula works, but it gives me an exact date (my referenced date plus the number of days referenced via the VLOOKUP). I've tried to incorporate the Workdays function without success and wonder if someone else might be able to help me. Here is the formula that works: =([PCD Draft 1 Start Date]@row +…
-
How to calculate a rolling actuals plus forecast to create an Estimate at Completion
Hello, I am trying to create a calculation that will give me an Estimate at Completion where it sums actual hours/cost up to today with the sum of forecasted hours/cost through the end of the project. I am struggling to get the date to be dynamic so it updates each week instead of having to manually adjust the columns that…
-
Nested Criteria on COLLECT
I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([Economy QTY]@row * (INDEX(COLLECT({Price Range}; {Type Range}; "Economy"; {Route Range}; CONTAINS(Route@row; @cell); {Active…