Formulas and Functions
Archives for October 2021
Discussion List
-
SUM entries MTD for each day and each monthIn Formulas and FunctionsI 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 …
-
Simple row multiplication formulaIn Formulas and FunctionsHey 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…
-
Automation not working as intendedIn Formulas and FunctionsHi 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 …
-
Multiple Contacts and effort totalIn Formulas and FunctionsHello, 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 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
SumIF/CountIF not WorkingIn Formulas and FunctionsHelp 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 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Trying to return text in a cell based on meeting two criteriaIn Formulas and FunctionsI 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 views 1 comment 0 points Most recent by Brent Wilson Formulas and Functions
-
Create Leaderboard with growing, non-static listIn Formulas and FunctionsI 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…
-
Formula adding previous daysIn Formulas and FunctionsMy 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Leave blank if SUM is zeroIn Formulas and FunctionsI 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 views 1 comment 0 points Most recent by Sheryl Roland Formulas and Functions
-
Conditional Formatting between 2 different SheetsIn Formulas and FunctionsHello, 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…