-
Can you automatically apply a format to parent rows?
I would like parents rows to be formatted bold automatically in my sheet. I looked into conditional formatting but it did not have an option to reconize parent rows. Is there anyway to do this?
-
Rounding in Formula
I would like to round the result of this formula. =(ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7)) / 3 + "%") KR1 Calc]7 = 0 [KR2 Calc]7 = 100 [KR3 Calc]7 = 100 [KR4 Calc]7 = 0 [KR5 Calc]7 = 0 Currently returning = 66.66667% I would like to round this to = 67%
-
Countifs
I am trying to use a COUNTIFS formula and it is returning a zero, even though it should return a one...I think it is user error...I checked the reference sheet and it refers to all the columns on the sheet... =COUNTIFS({SVC Support Priority Range 1}, "[Urgent - Drop Everything]", {SVC Support Priority Range 1}, "In…
-
Countifs: Using a reference for the criterion
I have a summary sheet that includes the following columns. * Ticket# * Last Name * First Name * Biosketch In the Biosketch column (and two others), I'm using the formula: =COUNTIFS({GH Ticket #}, 1114, {Last Name}, "Meyer", {Bio}, 1) I would prefer to use a reference to the column in the summary sheet instead of typing…
-
RYG balls formula displaying text only
I've read through all the replies on this but have not found the resolution yet I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date. The new column Properties is RYG Balls The formula works, but only shows as text Formula i created: =IF(Status@row = "Complete",…
-
Automating RGY balls
Hello, I am trying to automate the Red, Green, Yellow balls in my project plan but I can't seem to make the formula work. I want this to be based on 2 criteria, one being % complete and the other one on the end date. So I've tried something like =IF([% Complete]1 < 1, IF(TODAY(3 / 5 / 2019) - [End Date]1 > 0, "Red")) and I…
-
Status Symbols
We don't want project teams to use yellow ball. Is it possible to have only Red and Green Balls as Drop Down Options to select for Status?
-
Record the number of times tasks are sent for review and need rework
Hi I have an automated flow with a status and want to record the # of times an operator changes a task to "for review" (which automatically notifies the review) and it goes back to "to do" because the reviewer doesn't accept the task as submitted. I looked at an IF function to write YES or NO to a hidden column so we can…
-
How to create formula to count upcoming tasks in the next 90 days?
I want to see how many tasks each project I have are upcoming in the next 90 days. I can run a report to see this information, but I want to be able to display it in an easy to read chart with each project showing how many tasks they have. See attached example. I built the attached chart by running the report with the…
-
Cross Sheet Logic/Data Sync
Hi, I have a signup sheet that I am trying to get to update from another sheet. I essentially want to take "Unique Code from cell X on Sheet A and look for it anywhere in Column "Code" on Sheet B. Once it finds it on Sheet B, I want it to return the data contents from another column in the corresponding row to Sheet A. For…