-
Prevent users from entering dates that put other tasks in the past
Our project managers are responsible for creating new projects in our schedule. They enter a install start date and contract date. The dates for all the other tasks are formula driven from the install date. The image below shows our engineering tasks. Those 3 projects where entered within the past two days. All of our…
-
Widget filter, IF statement, or what?
I have a dashboard that provides counts of certain data. One of the counts needs to be date-driven in the respect that it needs to show the count for the current year. How do I build that into the widget?
-
=SUM - Military Time conditional calculation Formula
Need help with calculation of military time: I have two columns that I am using to track Admission time and Discharged time to determine and average length of stay. I am using military time for each column and storing the difference in a third column for each row =SUM(([Discharge Time From ER]2 - [Admit Time]2) / 100) Exp…
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
If(And) #unpareseable error- help
Hi I am trying to write a formula to check values in two columns to set a flag on or off. If I write them independently without the AND function they work but when I write it with the AND I get a #unparseable Error. Here is the formula- =IF(And([Planned Finish]@row > TODAY(), [% Complete]@row > "100%") 0, 1). Any guidance…
-
Formula for Parent, Child, and Non-parent/child rows
I need a formula that encompasses all three of the scenarios listed below. In my case, I have a Project ID system-generated column and a Rep_Project_ID column for grouping related tasks. I want parent rows and non-parent/non-child rows to copy the same-row Project ID and child rows to copy the parent Rep_Project_ID number.…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Issue with COLLECT and duplicate dates
We are trying to achieve a formula that finds the most current Tracked task's Variance from the Baseline date. Tasks are arranged in a table/schedule in step by step order. I'm having an issue with this formula here: =INDEX([Baseline Variance]5:[Baseline Variance]128, MATCH(MAX(COLLECT([Task Complete Actual]5:[Task…
-
Hiding NULLs in imported dates
I am importing an Excel with some NULL dates. How do I display empty cells instead of NULL? Thanks!
-
Formula for only Children rows but excludes Parent rows
Does anyone have any ideas or a sample formula where a value can only be applied within a column to rows that are of children level? So essentially, if its a parent row it doesn't insert any value within the column, but if its a child row it populates that same column with a value.