-
SUM entries MTD for each day and each month
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 end of each month. Is there a way to do this automatically so I don't have to restart…
-
Simple row multiplication formula
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 by a fixed number. I am not multiplying two rows together. What's the correct way to…
-
Automation not working as intended
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 changed in the last couple of weeks, because it's fallen on its face and I'm having…
-
Multiple Contacts and effort total
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 effort for all child tasks. I would like to allow the Assigned To column to use…
-
SumIF/CountIF not Working
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), $PPE@row, ([Timecard Complete Helper]$10:[Timecard Complete Helper]$172)) I'm trying to get the 'Timecard Completed' column to count the…
-
Trying to return text in a cell based on meeting two criteria
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 return the score based on the state and the project name. So for example below (this was…
-
Create Leaderboard with growing, non-static list
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 time and I would like to the leaderboard to reflect that growth. So when 21st, 22nd, etc…
-
Formula adding previous days
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, no date is present. This is my summary sheet to add up done and undone checkboxes…
-
Leave blank if SUM is zero
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]:[MD FTE] > 0, IF([APP FTE]:[APP FTE] > 0, SUM([MD FTE]:[MD FTE], [APP FTE]:[APP…
-
Conditional Formatting between 2 different Sheets
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 request. Can be done now? Thanks!
