-
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…
-
How to write a formula if then formula with multiple conditions
The formula I am looking for is if a PO Amount is greater than 50,000 then return a circle but if it is greater than 100,000 return a square and if it is less than 50,000 return a triangle. I have tried =IF([PO Amount]@row <50,000, "triangle", IF[PO Amount]@row >50,000, circle, IF[PO Amount]@row >100,000, "square") this…
-
How do I write a formula that returns a circle if a PO value in another column is greater than $100
=IF(["PO Amount"] > $10, "Circle", ["PO Amount"] <$10, "Square")