Calculate cell value based on various cell look up functions
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
Help Article Resources
Check out the Formula Handbook template!