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
-
Responding to form submissionsIn Formulas and FunctionsI'm setting up a form for non-licensed users (requestors) to submit inquiries regarding the status of our projects. I have the form set up so that my team can provide a response to the inquiry within the form when they receive a notificati…
-
Countifs Contains part with an identifierIn Formulas and FunctionsHello, I'm trying to create a formula to count how many stores we have for a certain date based on the nomenclature of the store name. I want to count stores that start with "W" example W001234 or W004566. I also want to cou…
-
Calculation of monthly durationIn Formulas and FunctionsHi All, I've been trying to find a formula to automatically calculate duration in months from start date and end date. I went through several threads here but none of them seems to fit at all. Could any of you advise? I presume it is somet…
-
today() function change dynamically in sheetIn Formulas and FunctionsUsing today() function in sheet, so date will change dynamically or when we access sheet then it will change.. For example, if someone took the above actions on Apr 3rd and then no one takes above actions in Apr 4~ Apr 6th, then the today …
-
Formula helpIn Formulas and Functions@Paul Newcome Reaching out for help again. How would you create an equation where the parent status is automatically updated when the child row statuses are changed. See attached picture. When all of the "Actuals" are "Com…
-
COUNTIFS Less than Today on a referenced sheet = INVALID OPERATIONIn Formulas and FunctionsI'm referencing another sheet and want to count rows belonging to a particular individual where the planned date is in the past. I'm trying to COUNTIF [email protected] and Planned date is less than TODAY() Here is my formula but I'm getting an I…
-
Formula on checkboxesIn Formulas and FunctionsHello all, I am trying to find a formula that will show me progress based on 3 or more columns that are checkboxes. I want to show progress if one of them is checked, I want this new column where the formula will be to say not started if …
-
Sum If HelpIn Formulas and FunctionsI'd like to sum the number of story points if "label" = "Unity_Beta" Then sum the number of story points if the "label" = "Unity_Beta" and the "Status" = done
-
RYG Ball & Status, Help neededIn Formulas and FunctionsHi, I'm trying to create a RYG color based on Status column, I have tried: Empty or Not started = RED In Progress = Yellow Complete = Green =IF([Status]3 = "Not Started", "Red", IF([Status]3 = "In Progress", …
-
How to work around this Cirular Reference Error?In Formulas and FunctionsHi everyone! I am working on an Inventory sheet for my business and it is not allowing me to do what I need, IE(CircularReference Error). I have a [Starting Inventory] set at 20 in my 'Master Inventory' Sheet. Then I have 2 Forms that are …