-
If Box is checked change priority to blue
How can i setup this scenario: I have one column with Priority and one column with checkboxes. I would like it to change the priority to blue (from red, yellow, green) if i check the box. I cant do this with conditional formatting, but maybe a formula can?
-
Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
-
How to display Days Elapsed only if Status is Open?
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tips would be highly appreciated!
-
Conditional Formatting Based on 2 Date Columns, with or without Helper Column
Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06/29/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06/29/2023 deadline,…
-
USing IF and ISBLANK with two columns
Please help. I posted this almost two months ago and still have gotten no help. I am currently using AT-RISK indicators for certain tasks that have not been closed. The first formula works but does not turn off on the indicator once the task is closed. =IF([Committed Closure Date]@row - TODAY() > 10, "Green",…
-
Using IF and ISBANK.. Please help!
Please help. I am currently using AT-RISK indicators for certain tasks that have not been closed. The first formula works but does not turn off on the indicator once the task is closed. =IF([Committed Closure Date]@row - TODAY() > 10, "Green", IF(AND([Committed Closure Date]@row - TODAY() >= 6, [Committed Closure Date]@row…
-
Conditional Format - Column Only
Is there a way to set a conditional format for either one or multiple columns and not the row? What I am attempting to do is high light negative numbers in three columns and to not want the entire row to be highlighted as it does not apply and is very distracting. Thank you for your response. Paul
-
Fast status updates based on parent cell
I would like to make our status updates faster by utilizing the parent/child cell(s). If the user changes the status in the parent cell (dark grey line) to "Completed" then the child and grandchild cells would change to completed. If the user marks the child cell as one of the following statuses then the grandchild rows…
-
Telephone Number Formatting (###-###-####)
Is there a way to format a column of numbers to be in telephone number format? NPA-NXX-NNNN?
