Formulas and Functions

Archives for October 2021

Discussion List

  • SUM entries MTD for each day and each month
    In Formulas and Functions
    I have a sheet with the date on each row starting 07/01/2021 through the end of the fiscal year, 06/30/2022. I need the month to date sum on each row. I sum each date with the date before but I have to manually change the formula at the …
    Accepted
    15 1
    Answered ✓ 15 views 1 comment Most recent by Sheryl Roland Formulas and Functions
  • Simple row multiplication formula
    In Formulas and Functions
    Hey all. Looking to have a row for an MSRP where the row shows the suggest 15% markup on a row. For example say row named COST is $100 and I want a markup of 15%, I want to create a formula to multiple COST row * 15% I am multiplying 1 row…
    Accepted
    45 7
    Answered ✓ 45 views 7 comments Most recent by Mycelus Formulas and Functions
  • Automation not working as intended
    In Formulas and Functions
    Hi all, I have a sheet in which I'm tracking installation dates of equipment (outside vendor) and have automation to fire off to ensure the necessary pieces all fall in line (in house), within a timely manner. However, something must have …
    Accepted
    53 4
    Answered ✓ 53 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Multiple Contacts and effort total
    In Formulas and Functions
    Hello, I am tracking tasks with an Assigned To column and Effort column. My original sheet required repeating the same task and assigning to each individual who would perform that task, and then using the Sum(Children()) to get the total e…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • SumIF/CountIF not Working
    In Formulas and Functions
    Help please... why is it that my formula is returning a "0" zalue in Timecard Completed1 field when it should technically return a "1"? Formula being used: =SUMIF(($PPE$10:$PPE$172), [email protected], ([Timecard Complete Helper…
    Answered - Pending Review
    26 1
    Answered - Pending Review 26 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Trying to return text in a cell based on meeting two criteria
    In Formulas and Functions
    I seem to be stuck. I have searched for answers in this forum and tried many formulas only to get errors. Think it probably a simple answer but can't seem to find it. I have a sheet that scores our programs on a scale. I am trying to ret…
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Brent Wilson Formulas and Functions
  • Create Leaderboard with growing, non-static list
    In Formulas and Functions
    I would like to create a leaderboard report using a list of names that is non-static. Meaning I have a list of 20 names today and I could create a leaderboard from that data, but the source sheet is going to have names added to it over tim…
    Accepted
    31 3
    Answered ✓ 31 views 3 comments Most recent by Ross Novotny Formulas and Functions
  • Formula adding previous days
    In Formulas and Functions
    My goal is to have a summary sheet that shows by day how many tasks each worker completed and how many they did not. The intake sheet is set up for them to enter the date when they input data so if they are on vacation or just don't do it…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Leave blank if SUM is zero
    In Formulas and Functions
    I found a few answer that I though would work for us, but I keep getting an Incorrect Argument error. I want to sum numbers in columns for a total, but leave the total blank if the sum is zero. Here is what I was trying: =IF(COUNT([MD FTE]…
    Answered - Pending Review
    48 1
    Answered - Pending Review 48 views 1 comment Most recent by Sheryl Roland Formulas and Functions
  • Conditional Formatting between 2 different Sheets
    In Formulas and Functions
    Hello, I am looking for an option to have a conditioning rule in one sheet and once changes, it triggers a format change in another sheet? I saw this question came up in 2016 and the support team said they will pass on as an enhancement re…
    Accepted
    14 10
    Answered ✓ 14 views 10 comments Most recent by TaliRXM Formulas and Functions