Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is the next closest upcoming date in the future. Help!!
As a note, I do have a P column that tells me the ancestors, so basically my formula will be:
=IF(P@row = 1, [NON REFUNDABLE DEPOSIT]@row, IF(P = 0, ?????
I also have a helper column that I am not sure if I need called "NET Days from Today" that basically tells me how many days away the "NON REFUNDABLE DEPOSIT" date is from today. So if I could someone use that and use the closest negative number from zero? Would that help??