-
Formula to change certains Dates
Hi I am hoping someone could please help me. I have attached a screen shot of three columns that will be used. What I need is a formulas that when the date paid is entered then the company review date will change by a full year and the when the company review date changes I want the due date to change by 2mths Thanks in…
-
Help with Formula for Unique IDs
Hello, I'm working on dashboard that will track a list of vendors. Some vendors have multiple locations, so the vendor name would appear the same from row to row with other fields unique to location, while other vendors only appear once because they only have one location. Those who have multiple locations only need to…
-
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…