Help with Formula Vlookup, collect, if?

Not sure if this is possible but I have a sheet to track monthly billing and another sheet to forecast milestone completions.

On the monthly billing sheets I want it to look at the milestone forecasting sheet and if a milestone is forecasted to complete in a month add a billings to the billing sheet.

Billing sheet looks like this:

For Test customer in each monthly Column I want it to look at the milestone sheet and if the project has a milestone dated for the referenced month pull in the correct billing.

This is the Milestone sheet for the customer:


This customer closes phase 3 in may 2023 so in the billing sheet I want to see nothing for Jan - april but in the May column it should pull in $11,512.50, and then in July $9210 so on and so forth and I have no idea where to even start

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!