Calculate cell value based on various cell look up functions

Hello Everyone,

I am trying to create some automation in my SmartSheet that will automatically calculate the estimated cost for a project based on 1) type of project 2) production hours 2) estimated development hours (based on production hours) 4) how much the cost will be based on hourly cost

For example, I have the column 'Production Hours'. I also have the Course Asset Type identified. How do I create a calculation that looks up the Course Asset Type from the hidden columns, then calculates the Estimated Development Hours & Estimated Development Cost (highlighted fields)?

So the calculation should - Consider Production Hours, Consider Asset Type, Look Up Asset Type in Training Course Assets, Based on the type, calculate the Estimated Development Hours based on Production Hours and Asset Type, then calculate Estimated Development Cost based on Production Hours and Asset Type

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!