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
-
I want to use a date in the parent row in a formula to generate another date (in the child row).In Formulas and FunctionsPartial data (some columns are hidden) I would like to use the IT Installation Date of the parent, to populate the Due Date of the Server is up in Store row. Then, I would like to use a different column (called SO Date) to calculate the 3 …
-
SUMIFS over dollar amount thresholdIn Formulas and FunctionsHi, I currently have a working formula that totals up amount of money for a specific company =SUMIFS({Cost 2021}, {Subsidiary 2021}, [email protected]) I now need that formula to be if the cost in column Cost 2021 is greater than 5,000 for th…
-
Formula to determine if created (Date) column matches a date column or is todayIn Formulas and FunctionsI have a form my team uses to record several instrument calibrations, with an auto generated created date for each entry. Is there a way to compare the created date to a date column in another sheet to see if the 2 columns match? Or maybe …
-
If/And StatementIn Formulas and FunctionsHey again, I am stuck with something a bit beyond my current skills. I need to write a formula that I believe will be an If/And Formula. The formula needs to populate the Case Status cell. If the the Tentative Return Date column is blank,…
-
How to I "not format" a number in a form?In Formulas and FunctionsOne of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even th…
-
Date column formula to start on a specific date and continue on after that.In Formulas and FunctionsHello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically…
-
Help setting up formula IFIn Formulas and FunctionsHi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH([email protected]) = 1, "January", IF(MONTH([email protected]) = 2, "February"....) Altho…
-
Reference/Link Cell Data from one sheet into another sheet's SummaryIn Formulas and FunctionsNeed an example of how to link or reference the value from a cell in one sheet (Project Intake Portal) into a field in the Summary of another sheet (Future New External Vendor Template)?
-
How match a value from a second sheet to a correlated dateIn Formulas and FunctionsI have two sheets, a primary sheet and a second sheet I'm using as a metric sheet. Sheet 1 (Primary sheet) Sheet 2 (Metric sheet) Some background. The first sheet uses a formula in the "Next Action Item Column" =IF([Year of …
-
Counting Distinct ID that excludes certain business titles and includes Open Status onlyIn Formulas and FunctionsHi can someone help me out with this one, =COUNTIFS(DISTINCT({Requisition ID}, {Business Title}, NOT(OR(@cell <> "MSS", @cell <> "Sales Engineering")))) I want to return the count of distinct req IDs, that …
