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

  • Answered - Pending Review 16 views 2 comments Most recent by Mark Vorstenbosch
  • Can I count data that is saved in a report?
    In Formulas and Functions
    I have a report that collects data from many sheets and gives me an output and a date. I need to count how many are in that report for a given date. Is there any way to count instances of something occurring in a report rather than a sheet…
    Accepted
    31 6
    Accepted Answer 31 views 6 comments Most recent by Genevieve P.
  • A way to place the Row ID (for APIs) into a cell value with formula?
    In Formulas and Functions
    For clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to whi…
    Answered - Pending Review
    31 2
    Answered - Pending Review 31 views 2 comments Most recent by Julio S.
  • Why doesn't my Automation with a email work?
    In Formulas and Functions
    Hello! I have set up an automation, where when a specific cell is changed to 85% and above, where a specific name is, it should notify the person and administrator. And my problem is that it doesn't notify the people. Note: there are about…
    Answered - Pending Review
    9 3
    Answered - Pending Review 9 views 3 comments Most recent by Andrée Starå
  • Auto checkbox problem
    In Formulas and Functions
    Hi, I am using these two formulas to auto check a box. =IF([Column Title1]@row = "Word", 1) =IF(ISDATE([Column Title2]@row),1) Both work individually, but i am having trouble nesting them and making them work together. I need th…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Nat O
  • Date Formula
    In Formulas and Functions
    I have two quick questions; I need a formular to express the following: End date of column A = Start date for column B ( I tried setting the columns equal to each other but get an error) Second formula Column C = Column B +10 ( I tried…
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by Sameer Karkhanis
  • Update date column when another column drop-down is selected
    In Formulas and Functions
    Looking for the formula to change a column to a date when another column drop-down is selected. The date would reflect the actual date the column drop-down list was selected Example If EPMO Stakeholder Decision (Approved, Declined, Deferr…
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Jermaine Johnson
  • Timing Issue for Moving Row from Staging Sheet to Main Sheet
    In Formulas and Functions
    I'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to ch…
    Answered - Pending Review
    16 4
    Answered - Pending Review 16 views 4 comments Most recent by Bethany Garcia
  • SUMIFS formula that includes a checkbox condition
    In Formulas and Functions
    Hi everyone, I'd like to sum all cells in a column that are (A) in a parent row (B) have a certain name in the Producer column. I've inserted a checkbox column (called "Parent") with a formula to check the box if the row is a par…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Kristina Todoric
  • Return a value, if a cell contains text from a range of options
    In Formulas and Functions
    Hi there! I'm not sure if there's an easy way to do this, so I'll try to break this out into parts: 1) I have a table with two columns - one with various text options (for easy, let's call these "flavours"), the other with the &q…
    Answered - Pending Review
    22 5
    Answered - Pending Review 22 views 5 comments Most recent by Jeff Reisman