User Profile
JoMoWasHere
Copper Contributor
Joined Aug 10, 2023
User Widgets
Recent Discussions
Re: Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Sorry, but you accessed the file through an opened OneDrive like you suggested. The file's name is SharePoint. I've just named it that because this is technically the file that I use to sandbox. EXTREME apologies that my organization is a little everywhere. I've changed things around and hopefully they make more sense, but here's a quick explanation. Starting from Approval Date the first 8 months should yield a "YES" true value. Months 9-12 "At Risk"... By months 13-23 "No". Finally, the start of the 24th month moving forward should turn to "Aged". I've been using the Renewal Date though as the point of date since it was easier from my own knowledge, but I'm all ears to other suggestions.Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Hi, Currently working on an excel formula to eventually put up on SharePoint. Unfortunately, SharePoint only provides me with 1 line for an excel formula and I'm trying to automate, in a sense, a status column based on dates. So far the Yes, At Risk, and No has been working, now I have to add an "Aged" as a return. This is the formula I have so far =IF(DATEDIF(TODAY(),E4,"Y")>2,"Aged",IF(E4<TODAY(),"No",IF(E4<(DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY()))),"At Risk",IF(TRUE,"Yes","")))) OneDrive link: https://contracostahsd-my.sharepoint.com/:x:/g/personal/jmoral2_cchealth_org/EZKpM6GVFhZGkX37Fwoqyo8BUqu8AdhPtEqOtVayts8aig?e=vv6ANh Any help will be appreciated. MANY thanks.Re: Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Appreciate the input and the feedback. Didn't think of actually put the file in GoogleDrive or OneDrive, it would be 1000x easier for help. Definitely will add it when I can and will try that formula out. Unfortunately, the IFS function is not supported on SharePoint so I have to stick with IF statement for now.Re: Formatting with date ranges
HansVogelaar Apologies, but is there a way around the EDATE? It doesn't seem like SharePoint likes/supports EDATE. Could be wrong though, but I keep getting an error and even when I isolate EDATE on a test column, it comes out as an error as well. P.S. Pretty amazing that you figured out E16 is Renewal Date. Just noticed that.Formatting with date ranges
Hi, I'm trying to figure out a formula at work and I might go bald trying to figure this out. The characteristics is that from the Approval Date it is a - 12 month duration (default, reflected in Renewal Date) - months 1-8 the result would be "Yes" - months 9-12 the result would be "At Risk" - months 13+ the result would be "No" This is the formula I have so far... Any help/suggestions would be appreciated! =IFS(E16<=TODAY(), "No",AND(TODAY()>=D16,TODAY()<=D16+275), "Yes", AND((E16-90)>=TODAY(), (E16<=TODAY)),"At Risk")
