-
SUMIFS based off Status and date?
I am building a counter for a team where they do a simple web form to say which task they did, and how many times they did it. There then needs to be a dashboard that then has a sum of that type of tasks completed during the current month, and the previous month (seperate). The FormData screenshot is the Grid that collects…
-
Testing multiple due dates against completion dates
Hey Community members I have a sheet that is tracking reporting compliance. Most of the reports only have ONE due date (typically reported annually ie 30th June), but there is a number that requires monthly and quarterly reporting. To allow our users to enter up to 12 dates for a reporting cycle we have 12 fields to…
-
Saving as New
If you save a workspace as new and rename it, would you also have to rename the sheets that are in the workspace? Just wondering if they were the same would that mess up any formulas? Thanks, Cheryl
-
AvgIF(Children)
Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!
-
SUMIFS using Fiscal Year Date Range
I'm trying to sum monetary amounts for a certain customer while referencing the data from a separate sheet. However, I only want to sum those amounts that fall within the FY20 (fiscal year) dates of 4/1/19 to 3/31/19. Here's the start of my formula that sums all dates, but what conditional formula do I need to add that…
-
Rank formula?
Is there any equivalent for rank formula on Excel? I would like to create a ranking column based on value of another column example : Score | Rank 20 | 2 30 | 1 2 | 5 12 | 3 5 | 4 Thanks
-
Sum of Values in Another Sheet, Using Collect
I would like to find the sum of the enrollments in a particular course from one sheet (Sheet 1), and display in another sheet (Sheet 2). Sheet 1 There are three columns, Course, Students, Term. Course | Students | Term BUS 101 | 12 | Summer BUS 101 | 33 | Summer BUS 101 | 15 | Fall ACT 223 | 16 | Fall CAR 322 | 4 | Fall…
-
Nested IF Statement
Hello, I am trying to create a status of "Adheres" or "Past Due" based of off comparing two date fields (A Target Date and an Actual Date). When I use this formula I get what I need. =IF([Target Audit Start Date]8 > [Actual Audit Start Date]8, "Adheres", "Past Due") The issue is that the actual date field will not be…
-
Count Number of Open Items in the Last Month by Day
I am trying to make a chart showing the number of open items each day in the last month. In the last month will be flexible so this will be a item that autopopulates the chart as the month goes on. I have a column for the formula =TODAY(-1), =TODAY(-2), etc. to populate the dates for the last 30 days. I have a "received"…
-
HELP with IF formula and Circular Reference
Hello, Here's the set up: I have Four columns I'm working with: Progress (Drop down menu) [the main option i'm working with is "to do"] Duration (Duration) [This column is based on how long we have to complete the project] H# (Number) [This is just a column that takes duration out of days to just numbers] Allocation %…