-
I want to count items within current month without needing to change the month manually
I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?
-
Why is a formula not triggering unless someone opens the sheet?
Hi there, I have 150 sheets that individuals use as time sheets. The sheet has rows for all the dates for a quarter. I have a "Current Month?" check box column in the sheet that checks the cell if the row date is in the current month. It uses this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) I have another check box…
-
COUNTIF with HAS formula
Hi, I'm trying to use a COUNTIF formula with a HAS criteria, but it doesn't seem to be working for me. Would someone mind taking a look? I'm trying to count the number of times "Apples" shows up in the multi-select column, Range A, while Range B also has "On Hold." Here's the formula: =COUNTIFS({Range A}, HAS({Range A},…
-
Multi Select HAS Formula
Hi I'm trying to get a sheet to count any projects where Finance Teams and / or Finance Systems are required to deliver a project at a particular status for a Portfolio dashboard metric. I'm currently using this formula but, it's not pulling the right info back - I'm getting a zero return when I'm expecting a number.…
-
AVG error message (with formula issues as well)
I'm trying to calculate the average score (1 to 5) of a column, but keep getting the DIVIDE BY ZERO message. The column with the scores is calculated via a formula from a column formatted with stars (from a survey form). So four stars from the survey = 4. But I noticed that all the results have a ' in front of them (e.g.…
-
Lead time question on approval request email
Hi, Does anyone know when changes happen how long it takes to receive an approval request email? It passed more than five hours but still not received the approval request email. Checked my spam box not there also. Thanks in advance for sharing!
-
Find and Replace within Formulas
Would love to be able to Find and Replace within Formulas, would save so much time..
-
ISBLANK formula not returning data when cell is blank
I have an automatically generated date column in my sheet 'Created Date'. I want to be able to override this date with a manually entered date 'Manual Date'. I created a new column called 'Inquiry Date' and am using this formula: =IF(ISBLANK([Manual Date]@row), [Created]@row, [Manual Date]@row) I want the formula to pull…
-
Formula to Select Multiple Dropdown Options using Two-Column Criteria
Hello, I am looking to be able to auto-populate the pending permits based on the empty date cells where we input our received dates. I currently have to manually choose what permits are missing, but am hoping there is a formula I can use to show both missing permits. Below is what it currently looks like and after that is…