Forum Discussion
Help with IFS Please
I'm unsure if I'm doing this right. This formula is entered into a follow up column and has 2 date columns as well as 2 y/n columns. Source table is from today formula(table). =IFS(J3<=Table1[To...
You've had 35+ views, no replies. I strongly suspect it's because it's not clear if you actually have a question, and, if so, what that question is.
- Your description of the organization of the data to which the formula refers is unclear at best, confusing for sure.
- Where the formula itself resides is not mentioned, so its relationship to the fuzzy data in their various columns is unclear.
- What the formula--if and when you get it working--is supposed to do, what its function is in the bigger scheme of things, is unclear.
My own firsthand experience is that if I'm not clear on what a conditional formula is supposed to be doing, the conditional formula will suffer from that lack of clarity. So you could help us help you if you back up and describe what's going on in everyday English, without reference to the formula; the formula will follow quite naturally after the bigger picture is clear.