-
Function Help - Sheet References
Hi there - I am working on building a slightly better project tracker for our organization. We currently utilize calculated fields that we have to define for each new project, and sometimes the project does not have enough project rows to account for all items we are tracking. I need help with a specific formula that would…
-
Return 1 if YEAR and MONTH is equal TODAY
Hi, I have a formula: =IFERROR(IF(MONTH([Sale Date]2) = MONTH(TODAY()), 1, IF(MONTH([Sale Date]2) = MONTH(TODAY()) - 1, 2)), " ") and it worked until we have two years in one sheet. I would like to know how to add YEAR to this formula so that we can compare not only MONTH but also YEAR. Thanks.
-
Formula in parent row for updates in child rows
Hello! I have my sheet set up so that all of the update columns in the child rows are automatically a red dot. Once a row has been updated the cell turns to a green dot. It will stay green for 4 days as I have the formula set up so that on Mondays I can see if any PM's have updated the sheet since Thursday (4 days…
-
Deleting one outgoing cross-sheet reference ended in ALL references from the same sheet being delete
Hello, I spoke to Support on the phone yesterday but we haven't had a definitive answer on what the expected behaviour for this scenario is. I'm curious to see what other users have experienced. In the the "Edit or Remove links" > "Outbound links" section of the Cell Links: Consolidate or Maintain Consistency of Data…
-
Adding some tricky pieces to an INDEX COLLECT formula
Anybody want to take a stab at this? I'm helping a design team estimate their effort based on the details of the work coming in. The formula will be an INDEX COLLECT with some nested IF statements. Note that this is currently on a test sheet and in the end the formula will live on an overall tactic sheet with cross-sheet…
-
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…
-
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…