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 Functions
    Partial 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 …
    Unanswered
    9 0
    Question 9 views 0 comments Started by megmeyer
  • SUMIFS over dollar amount threshold
    In Formulas and Functions
    Hi, 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…
    Answered - Pending Review
    20 2
    Answered - Pending Review 20 views 2 comments Most recent by Jessica Zahner
  • Formula to determine if created (Date) column matches a date column or is today
    In Formulas and Functions
    I 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 …
    Accepted
    19 8
    Accepted Answer 19 views 8 comments Most recent by Jeff Reisman
  • If/And Statement
    In Formulas and Functions
    Hey 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,…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Jeff Reisman
  • How to I "not format" a number in a form?
    In Formulas and Functions
    One 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…
    114 21
    114 views 21 comments Most recent by Caroline Sheldon
  • Date column formula to start on a specific date and continue on after that.
    In Formulas and Functions
    Hello, 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…
    Unanswered
    11 0
    Question 11 views 0 comments Started by Kaleb Riley
  • Help setting up formula IF
    In Formulas and Functions
    Hi 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…
    Accepted
    18 2
    Accepted Answer 18 views 2 comments Most recent by Jeff Beltran
  • Reference/Link Cell Data from one sheet into another sheet's Summary
    In Formulas and Functions
    Need 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)?
    Accepted
    33 11
    Accepted Answer 33 views 11 comments Most recent by Genevieve P.
  • How match a value from a second sheet to a correlated date
    In Formulas and Functions
    I 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 …
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by JBerm
  • Counting Distinct ID that excludes certain business titles and includes Open Status only
    In Formulas and Functions
    Hi 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 …
    Unanswered
    10 0
    Question 10 views 0 comments Started by Julius Wilson