Need Help, Nested If Date formula

I am trying to streamline a sheet that is used for project payment forecasting. The goal is to use the project's estimated ship date, when 40% of the project total is due, and have the 40% amount cell be copied into the corresponding date columns. I have a column for each month going to the end of the year. The sheet is a bit cluttered but I use reports to organize data in a neater way.

what I am trying to accomplish is, if the [ESTIMATED SHIP DATE] cell is not blank & is a date, then take [INVOICED AMOUNT] from the same row and copy it into the correct month column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!