-
Date field minus 'TODAY()
Hello All, Could someone please explain why the following doesn't work or a solution: I have a date column with a mix of dates both past and future. The next column is a column to say how many days till this date occurs. Therefore if it is in the future (i.e. date is the 30/10/20) then the second column needs to say 534.…
-
Is there a way to use a countif formula if the cell reference is a formula as well?
Hi All, Any help would be appreciated. I get #NO MATCH when I run the below formula. Is it an issue with a formula referencing a formula? ="Not Completed: " + COUNTIF([Column3]2:[Column3]24, FIND("Not Completed", @cell) > 0)
-
IF auto generated number in Row matches anywhere in 2 sheet columns then checkbox checked
Hello, I am trying to input a formula that automatically checks a checkbox when an auto generated number from a specific row in one sheet, is found anywhere in a column from 2 separate sheets. I've tried to make it work by referencing just one of the two sheets but it is behaving strangely. The formula I tried is…
-
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…