Forum Discussion
Long IF formula to addon if more than 24 months, then TRUE is "Aged"
Unfortunately, the IFS function is not supported on SharePoint so I have to stick with IF statement for now.
- Don't blame you. Should be in the post as well
https://contracostahsd-my.sharepoint.com/:x:/g/personal/jmoral2_cchealth_org/EZKpM6GVFhZGkX37Fwoqyo8BUqu8AdhPtEqOtVayts8aig?e=vv6ANhOK, I went in and looked. The first thing I tried was the IFS function and it was accepted. Maybe my subscription to Microsoft 365 is the difference? I'm not a Sharepoint user, but opened your file directly from the link IN Sharepoint......
Anyway I found myself unable to decipher what your conditions were and how they related to the data displayed.
- In the first line, the Renewal date is basically two years in advance of the Approval date
- In the second line, the renewal date is exactly 12 months after approval, yet the condition line reads "months 1-8 is 'Yes'"
- in the third line, there's one month from Approval to Renewal, but the condition description reads "months 9-12 is 'At Risk'"
- and so on.
Now, perhaps those lines aren't meant to line up; perhaps you're saying that the whole formula returns wrong answers in every case; I thought you were just trying to add the "Aged" condition but don't see where that meets any of your trial data.
But now that it looks like IFS does work, maybe you can resolve it yourself.
I'd be happy to help if you can come back and clarify what those conditions are and how they related to your trial data.
- 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.