-
IF HAS Formula for Contact List
I want the "Office(s)" field to display "OSA" if the Task Owner contains All. The Task Owner may have multiple contact lists selected. Current Formula: =IF(CONTAINS(All, [Task Owner]@row, "OSA", "")) Error: #Unparsable Columns: Task Owner - Contact List Office(s) - Text If I change the formula to include quotes about…
-
Formula to calculate number of day in process
Looking for a formula to calculate the number of days in process until a completion date is entered? I would like the number of days in process to show for tracking, but stop calculating when a completion date has been entered. =NETWORKDAYS([Received Date]@row, TODAY()) If I add 3/19/22 to the completion date column, the…
-
Count new event attendees with a formula
Hello, I work for an event based organization. Each of our events belongs to three separate programs (represented "M", "X" and "S" in my formula). We track all of our yearly attendance data in one master sheet with separate columns for program type, event type and each attending group's attendance at the event. All column…
-
#Invalid Column Value
I have this formula that is working correctly. I just want to add an IFERROR or IF(ISBLANK) to the formula so when the child row is blank, the parent row that this formula is in, will be blank until the child row has data entered. Below is the formula I am currently using. =INDEX(CHILDREN([Movment History]@row),…
-
Formula for counting the number of times Incident OR Near Misses are reported in a Year
Hi, I am trying to write a formula for counting the number of times we have incidents OR near misses reported in a year. The formula =COUNTIFS({Aviation Safety Reports Range 1}, =2020, {Aviation Safety Reports Range 2}, "Incident") is working for counting just incidents, but when I try to add an OR "Near Miss" on, it…
-
IF Formula for Value of Child@row and Descendants
Hello, I need a column formula to display the value(s) of the children up through all the parents. The JOIN part of the formula below does this. However, if the child doesn't have a descendant value in it, I want it to display the value from that row. The first part of the formula below is what I was hoping would take care…
-
Tracking Renewal Increases Formula
Hello! I need some help putting together a formula to track year to date renewal increases. My criteria is Underwriting Status needs to be set at "Completed Increase" and i need the sum of all the rates for increases to insurance premiums. I need to total for each row and have a YTD total at the top. For my row formula I…
-
I'd like the values in cells that are certain columns of Parent to equal most recent Child value
The screen shot of the actual sheet we're using, should be self explanatory.
-
SUMIF Using criteria from the Sheet Summary
Hi, I have a sheet that captures hours from a vendor. Hours and rework counts (number of times an issue goes into rework) are entered. I need to sum hours and rework counts for the previous month. I have a calculation in the sheet summary the takes the year and month and forms a YYYY-MM field. I am comparing this sheet…
-
Formula to get reduced value
Hello Expert here, New to SS. I need help on the formula that can derive the value of license with every entry. Eg: I have 5 license(A/B/C/D/E) with each $10,00 value and every time I make an entry let say of $100 of any random license number how can i get initial license value- the closing value. Kindly refer to below…