-
Date columns that update when a certain cell in another column is edited
Hello community I am keen to see if there is a way to add a column that populates the date when my 'done' check box is checked (in the same row). Has anyone been able to do that ? Regards Rebecca
-
Multiple IF Formulas Based off a Date
Hello Everyone, I'm trying to create a formula with multiple IF statements. So far, I have the following created: =IF([OH Date Qualified]@row < TODAY(-1080), "Designer 2"), IF([OH Date Qualified]@row < TODAY(-1800), "Designer 3"), IF([OH Date Qualified]@row < TODAY(-3600), "Designer 4") However, the above formula only…
-
Status Formula...
I'm really struggling to get my status formula to update appropriately in my project schedule. I've tried so many different formulas and hidden columns I'm starting to lose my mind! What I want: If Planned start date is <today and % cmpl is 0, then 'not started' If planned start date is >today and % complete is < the…
-
Heres and easy one, I dont know what i am doing wrong thou
I have a registration sheet that records registrations for different exams, I also have a column that confirms if the person that registered actually sat the exam, I want to count all the people sitting (sat) the exam for exam 1, exam 2 exams 3 etc.... where am I going wrong. =COUNTIFS([Sat]:[Sat], ="true", [Exam…
-
Date Formulas Do Not Auto Update?
I have several sheets with formulas calculating the difference between a given date and the current date. This formula only updates upon opening the sheet and then saving. I have about 25 sheets, this means for the calculation to update daily, I need to open each of the 25 sheets to update each of their formulas. Is there…
-
Nested IF statements with RYB symbols
I am trying to use RYG fill symbols in a nested if statement. if % complete is 100% = Green if % complete is less then 70% = Red if % complete is greater then 70% and less then 100% = Yellow Here is what I have, and I am getting a #INCORRECT ARGUMENT =IF([% Complete]@row = 1, "Green", IF([% Complete]@row < 0.7, "Red",…
-
How can I change the color on the calendar by employee name?
Example: I have a task name, audience and name of responsible Party in my grid view, if I change to calendar view I want to see the task name by color on the calendar. For example: Career is the task name and responsible party is Jackie Goal setting is the task name and responsible party is Vicki When I look at the…
-
Average duration for a specific type
I am trying to calculate the average time (based on #2) per request type (i.e multiple request types and trying to get the average per type in my Request Metrics form) Columns: Request Type Actual Days to Completion (this is calculated via formula of date ending - date initiated) I am not really sure where to start with…
-
Is there a way to specify which rows I want in a metrics sheet for widgets?
Hi, I have a metrics page that links to a sheet with data on it. The metrics I am interested in are attached. On the dashboard, we are using a donut graph to show all four categories: Red, Green, Yellow, Gray. But now I want to create another one that only shows Yellow and Grey metrics (e.g., 5 hour training completed…
-
NETDAYS with Contains...or maybe IF....
I have a multi-select column and a created date column(System). Im trying to get the netdays since at least one selection in the multi select was chosen and a row was created for it. I know Im missing a CONTAINS in here...I think...help is appreciated. =IF(Pri/Sec/Base/Water/Sand @row = "Primary", TODAY() - [Created] @row,…
