-
Help with SUMIFS
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},…
-
Formula Help Extracting Month Only from Formula Driven Column
Hi all- I need help trying to extract the month number from another column. My 'Notification Date' column uses a formula (based on the service 'Type') to calculate a specific timeframe. I need to extract only the month from this 'Notification Date' and populate it in the 'Annual Review Month #' column. I was good until I…
-
Overdue is not working when today date is greater than Overdue
I could use some help with my formula. The "Overdue" is not working when TODAY is greater than Overdue Date. Please see formula below. =IF(NOT(ISBLANK([Complete / Decision Date]@row )), "Completed", IF(ISBLANK([Start Date]@row ), "Not Started", IF(ISBLANK([Due Date]@row ), IF(TODAY() < [Start Date]@row , "Not Started", "In…
-
Converting days to months
I'm using the formula below to convert the duration in days to duration in months in another column, but I would like to join that result with "m" or "months" so its clear to PMs what they are looking at. I've tried a couple forumulas, but nothing is working. Does anyone have a recommendation? =ROUND(Duration@row / 30.44,…
-
Formula for SUMIF all orders within last 90 days
I have an order sheet where individuals can order items, but we have a restriction that they can only order 5 "coupons" in a 90 day period. I need a "Block Order" box to be checked on the row if The order is > 5 "coupons" OR If the individual ordering has ordered > 5 "coupons" over the last 90 days (may be in multiple…
-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
HELP WITH INDEX/MATCH ACROSS MULTIPLE COLUMNS WITH CRITERIA
Looking for formula help to accomplish the example below:
-
Using IF, Index, Match
Hello, I need a formula that will create the response "Green" if the Agency name matches the "Live Agencies" sheet to my current sheet, as well as have any of the following services (485 Review, OASIS/485 Review (No coding), or Non-OASIS 485 Review) in the "Coding Services" column of the "Live Agencies" sheet and create…
-
Dynamic formula to update a cell with a URL & Display Text
When I create a URL in a cell, it consists of the URL, and Display Text. How do I write a formula to, say, add the value from the autonumber field onto the end of the URL, and then display the autonumber field text as the Display Text?