Determine proof dates based on asset lead times

I want to determine a 1st proof due date based on asset type and days to complete. I have another Smartsheet listing all asset types and # of days. I have various columns that list asset choices. when any of these columns have an asset type listed I want to reference the other sheet pull in the days and have it provide a date the 1st proof should be completed by. this is so complicated not sure if I can achieve this. I am using a grid not a project plan to display the information at a high level.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!