-
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?
-
Nonparseable error using IFError
this formula keeps an error. =IFERROR(INDEX(DISTINCT({Project Info PM}), ROW()), "")
-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…