-
Formula using AND and OR functions
Hello, I'm trying to build a formula to count the number of deployments in queue by month. All of these criteria must be met: Project Complete is unchecked Project Cancelled is unchecked Row creation month is June Row creation year is 2022 And, deployment type is either New Deployment or Package Upgrade. I started with…
-
Updates Occur After Date Specified is Reached
I need for updates to Profile sheet to pull data from Exception sheet only when the date is reached based on the employee #. Scenario: An employee wants to increase their 401K contribution by $100 every quarter. Profile has Benefit Effective Date: 4/1/22, 401K Contribution: $100. Exception sheet has 3 exceptions submitted:…
-
Help with quarter and YTD function - reference sheet error
Hi Folks! I'm working on creating reports for an audit review process, and I'm having some difficulty with getting the report per quarter and YTD formulas to function. Here is the issue that I'm having. I need the @cell part to reference the Date of Encounter on my data sheet. However, when I try to do that, it gives me an…
-
Today Function used in Automated Workflow not Working
Hello, We have set up an automated workflow using the Today() function as the system date. If the today function is between a certain time period, then we want the Term Column to change. When the term column changes, it will change the Term Start Date Column and Term End Date columns which use an INDEX/MATCH formula. We…
-
Formula Help Needed - IF Statement w/ Multiple Conditions
Hi- I'm attempting to return the "Green, Yellow, Red, Gray" colors with a column formula based off the Status and Planned Completion Date of my tasks.
-
How to find average considering multiple criteria?
Looking to find the average margin(%) of transportation lanes which have a Transportation Solution that is "Full Truckload" and the rate quote is "Approved". i have tried several different formulas shown below. Disclaimer, not a formula expert. =IF(AND({Leg 1 Sales Quote Tracker Capture Form Range 4} = "Full Truckload",…
-
Sum Of Children Not Working
Anyone have any idea as to why the "=SUM(CHILDREN())" function won't actually work on certain columns? In the attached image, you can see that "March 2022 Hours Scheduled" in Row 1 is accurately gathering the sum of its children. But "April 2022 Hours Scheduled" in Row 1 is not. "May 2022 Hours Scheduled" is working. But…
-
Formula Help
I am currently trying to build a formula that will take into account if both averages are greater than 80 OR a box is checked to then display the word Pass. This is the formula I previously used to account if the averages over 80, but something came up i wasn't expecting that also results in a pass so i added the checkbox.…
-
SUMIFS from 2 sheets
I use the formula below to add up work amounts on a weekly basis. rows get moved to another sheet once they are shipped. To keep history I need it to check from both sheets. =SUMIFS({Master JOBV Range 1}, {MASTER SCHEDULE Range 1}, AND(IFERROR(WEEKNUMBER(DATEONLY(@cell)), 0) = Week@row, IFERROR(YEAR(DATEONLY(@cell)), 0) =…
-
Find Top Value projects and Sort
Hi , Can you please help. I have the "data set" which Project and Revenue. The requirement is a. To automate where top 3 projects by revenue can get populate and b. then get sorted by revenue value At this time, I am typing the project names manually and then doing Index(Collect) the Revenue by project name
