-
Countif query with blanks
Hi, I've had a search through the community but I can't seem to get a working formula so hopefully someone can help me. I'm trying to count if Issued Date is not blank and Responded Date is Blank. =IF(AND(NOT(ISBLANK([Issued Date])), [Responded Date] = ""), 1, 0)
-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
Is There a FUNCTION formula? (Turns a string of text into a formula)
I am trying to create a formula that copies the content of a cell from a precedessor row. Ive tried using this formula: ="=[Column Name]" + PredecessorsX which gives me the text value (=[Column Name]N) which is the formula I want in the cell but its not the formula itself. Any suggestions?
-
Handling request times within certain business hours
Hi I am looking for a way to calculate the number of days between when a row is added and when it is marked as "complete." I currently have a column set up with the submission timestamp. I also have a "date completed" column. I want to exclude weekends and holidays which seems simple enough, but I would also like to set a…
-
SUMIFS Function Not Working
Hi Community! Please see below screenshots, 1st image has the SUMIFS formulae and columns used to create this, and 2nd image is the output result "TotalVacationhoursScheduled". The problem is this SUMIFS is not working as it is not adding up the number of hours from "VacationCalculatedHours" column back to…
-
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…