-
Calculate % on time deliveries for team
Hi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC") / COUNTIF(Reviewer:Reviewer, "ABC") We have several team members, so what formula could I use to…
-
Filter by Week
Hi, Relative newbie here. Im creating a smart sheet for the maintenance planning and scheduling at my work. The idea is that once jobs are planned they can be added to the sheet, and with filters made set by week number IE week40....... Easy enough The problem I am having is if a task duration is 3 weeks long as an…
-
Why is my VLOOKUP returning erroneous data?
I am using a cross-sheet VLOOKUP formula on several rows in a master sheet. It is working correctly in one column, but for the other column the formula is returning erroneous data for only a few rows. For instance, in a couple of cases it is finding a search value that does not exist in the referenced sheet, then returning…
-
Count if Specific Text within a Date Range
I'm trying to create a formula to count a specific text within a column only when it's during a specific date range. I can't figure out where my error is. =COUNTIFS([Branch Selected]:[Branch Selected], "East Branch", [Date]:[Date], >= [2020-08-01], [Date]:[Date], <=[2020-08-31])
-
How to fill of data automatically via Master sheet to Child Sheets?
Hi, I have a scenario where I have a Master Sheet that is attached to a request form. I have more than 1 child sheet attached to this sheet. Not I want rows of these child sheet to be filed up depending on the text entry of a column in the master sheet. I tried VLookup, Index Match but not working it just fetches out the…
-
Status Colours - comparing dates
Hi Quite new to SS, but have been tasked with trying to update a current sheet to show a colour status column. I have 2 columns which hold dates, with some of the data been pulled in from other sheets, thats need comparing. If someone can help with the formula to show Green, amber, red status dots depending on the below…
-
Automatically Counting All Drop Down Choices
Hi, I have a drop down column with different names and this across multiple sheets. I would like to be able to know at all times how many times these names appear across in my rows across the sheets, and if a name appears more than say 65 times, be alerted. I have a sheet summary that leads back into a report currently,…
-
Column formulas
Can I assign a formula to an entire column so I don't have to keep copying the formula to the next row?
-
Change just once a formula used several times
Hello, I have a sheet that it is a summary of several sheets and I have a lot of formulas that use date like "<=DATE(2020; 9; 4))" and I want to change that part of the formula to for example "<=DATE(2020; 9; 6))" and just do it once because I have that several several times. Is there any way to do it? If I try to search…
-
Using a Relative Date in COUNTIFS Formula
I'm looking to use a relative date in my COUNTIFS formula (ex: In the next 7 days). This needs to be evergreen so I don't have to be updating the dates every day to have an accurate count so I need a relative date functionality rather than using a lesser than-greater than formula.
