-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
-
Formula for child row seq#
What formula needs to be in column Step# rows 3-7 to automatically keep the Step# in sequence when a child row moves up/down?
-
Health Formula
In my task sheet health column I am trying to write a formula that I desperately need help with. I have a column labeled status. It is a drop down column where I can select "Not Started", "In Progress", or "Complete". I would like my health column to reflect a color based on the input in the status column. Green if it is…
-
Change dot color based on date field
I am trying to come up with a formula that will change a RYG symbol to green if the date in another column is within the first 14 days of a month. The symbol column is already set up with the right column type. Thank you for the help!
-
Change a checkbox state in one sheet based on the symbol in another sheet.
I want to check a box in my metadata sheet (restricted to checkbox column) if the overall health of my project is red. The referenced cell/column is restricted to symbols, green, yellow, and red circles. The formula I came up with is returning #INVALID REF. This will all end up in a report and will be an automated process…
-
Comparing Columns on Two Different Sheets
I have two sheets that I need to compare data and highlight any matching data. If Sheet "A" query column matches any of the data in Sheet "B" query column, then the matching data in Sheet "B" query column needs to highlight. I've not had any luck finding a formula that works. Any thoughts?
-
Index Match function with specific criteria
Hello, I have successfully put together a formula to pull an Investigation tracking number to a cell when the product name on the new sheet matches the product name on the Investigation Tracker sheet. =IFERROR(INDEX({Investigation Tracker Range 1}, MATCH([PO Item Description]@row, {Investigation Tracker Range 3}, 0)), "")…
-
Combining the WEEKNUMBER and YEAR formulas
Hi, We have many live projects at any one time which all share cross functional resources. I want to create a report which shows all tasks, per week, on all projects. To do this I have added a column showing the Year Week using the formula WEEKNUMBER. However our projects are long, 2+years in some instances. So if I were…
-
Can anyone show me an example of negative float?
I know what it is, but I am trying to replicate it in a project plan. Every time I try to do it, the End Date of the project just gets pushed out, making negative float impossible. I'm wondering if the project end date needs to be a fixed date that cannot be moved in order to do this. If that is the case, is there a way…
-
SUMIFS
I can not get this simple formula to work: =SUMIFS([Grade K: RGR Countdown Student Workbook]:[RGR Countdown Student Workbook]):(If[School/Location: "Amity Creek"]) When I click on the Columns, I get errors - how do I state everything in the column?
