-
How do I populate dates from a date column into my date formula?
I'm running a Countif function that counts production between two dates, currently my formula looks something like this: =COUNTIFS({Reference Column}, <=DATE(2024, 1, 5), {Reference Column}, >=DATE(2024, 1, 1)). For the date part of my formula, is there any way to input dates from two date columns so that I don't manually…
-
Formula does not appear to be working
Okay, first, here is my formula: =IF([Release Name]@row = "", "", IF(COUNT(ANCESTORS()) = 0, 1)) It is in the far right (second image) in the column named Is Parent, which is a checkbox. I only noticed this issue as a result of checking on these release numbers that are a variation of the same number with letters as a…
-
Cell Link/Reference - COUNT Question
Good Afternoon all, hoping for some assistance with this formula I am putting together. For my Number of Dealers Column on Sheet 1, I am trying to get a formula to count the number of Dealer ID's that fall under a certain Market. For Sheet 1 the formula will be looking up cells from Sheet 2. The formula needs to match the…
-
Help with URL Query Text Field with multiple websites and subsequent fields.
Hi, I have a pre populated form that is populating appropriately until I get to a TEXT FIELD labeled "URL to Supporting Document(s)" where end users can provide URL web addresses to supporting documents. When a new row is added, an alert is sent to Approvers with the "Approval Form" link in the body of the email they can…
-
Checking for values across multiple columns
I am trying to write a formula that checks for blanks across 4 columns until it finds a value. I have researched this much and have written countless formulas with no luck. Can someone help me out here? Below is what I am trying to achieve.
-
Autopopulating formulas for column
Hi, Is there anyway we can have a parent row column and have the formula "=IF(COUNT(CHILDREN(FindingType@row)) > 0, 1)" auto-populate instead of having to type each formula for every row of that column? I would like the formula to actually show as 1 for the parent row instead of '=IF(COUNT(CHILDREN(FindingType@row)) > 0,…
-
COUNTIFS for prior period
Hi, I am looking to build a dashboard that displays prior month/quarter/year data. I have found ways to do this from a rolling perspective (Year (Today())-1) or specifying a year, such as (Year='2023')@Row, but none that appear to be scalable. I don't want to have to recreate any summary fields (with formulas)/reports/dash…
-
How to extract time from Date created auto column?
Hi all, I want to extract only time from Date created auto column (in format HH:mm:ss) I've tried VALUE(RIGHT(Created@row, 8)), but it seems i can only take two first numbers and ":" is blocking the formula, and i get unparsable if i go any higher than VALUE(RIGHT(Created@row, 2)). What would be the correct approach to…
-
#Incorrect argument due to #Divide by zero
I have been attempting to create a formula where I will not have to manually update this every month. My "OSHA Loss Time Rate" is broke down by month (Jan-Dec rows), the 7.78 formula is "=(([Lost Time Cases]@row * 200000) / [Hours Worked]@row)", however if I do not have any hours in or a 0, it shows the #DIVIDE BY ZERO,…
-
COUNTIFS formula does not work
I have a table where I have workstreams and configuration items and work how many config items per tower. I am struggling with formula and feeling really exhausted! I am using" =COUNTIFS({Config Item}, {Tower}, "OTCP")" and I get incorrect argument set. Please can someone help how I should write this formula🤬