If Comment is not blank, then show the recent comment and date
I have a Follow Up Date column and a Comments column. I have predetermined dates under the Follow Up column. I would like a formula to populate the most recent Follow Up Date and the corresponding Comments on the parent rows only if the Comments are not blank.
Any help is appreciated! Thank you!
Help Article Resources
Check out the Formula Handbook template!