Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
INDEX/MATCH not workingIn Formulas and FunctionsBelow are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the right is: =TODAY() On the target s…
-
Formula and RYG ballsIn Formulas and FunctionsHELP!!!!!! How do i create a formula to use RYG balls in the status column with % Complete column no matter how many videos and threads i look through!! I have a status column I also have a % Complete column I want to use balls to sho…
-
Countdown from today not workingIn Formulas and FunctionsI am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't r…
-
Formular to show tasks marked 100% in past 7 days, 30 days by userIn Formulas and FunctionsHello, I am trying to add formular to sheets to show the tasks that have been marked 100% for each user in a certain time period, ie past 7 days, or 30 days etc. This data will be shown in a widget on our report page for team dashboard. …
-
RYG with vlookupIn Formulas and FunctionsHello, I need my sheet to lookup an employee's id number on a second sheet and return a RYG ball depending on the code in the 8th column. I tried this with no luck: =IF(VLOOKUP([Employee #]1, {EIC Range 3},8,False)="Yes","…
-
Formula help pleaseIn Formulas and FunctionsHi, looking for some help please. I want to count a financial figure when the status is not received. Columns i am using are Start up budget and Received status. Probably really easy for someone, but am struggling with formulas as quite…
-
Sum If formula question - Don't want to sum if it's a lossIn Formulas and FunctionsHello! I'm currently using a Sum If formula that works to sum up by each lead, however, once we turn the Sales Stage to Loss I would like to remove the losses from the sum for that person's weighted forecast. The formula below is filterin…
-
Invalid data type/unparsable for date countdownIn Formulas and FunctionsI'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are some of the formulas I've tried with…
-
IF Statement and HealthIn Formulas and FunctionsI am trying to use the following IF statements for my health column. I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work. Can anyone tell me what I am do…
-
Month not displaying correctlyIn Formulas and FunctionsI have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11…
