Formula to auto fill date based on last non blank
I figured out the formula to give me exactly what I need in Excel:
This formula does not translate to smartsheet. I need a formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month.
Help Article Resources
Check out the Formula Handbook template!