If Statement Help
It's been a while since I've used smartsheets and I"m dusting off some cobwebs.
I have a column in my data set that determines the Project Type of a topic (i.e Course, certification etc.) Based on the Project Type, we have an formula per type that helps us calculate an estimated timeline.
I'd like to create a column that has an formula that will provide an estimated # of hours based on the project type.
For Example: Project A is a Course that is expected to have 4 modules.
Our formula to provide an estimated timeframe is:
(# modules x 30 hours) + 120 hours (our logistics turn around) --> (4x30)+120= 240 hours of work estimated.
How can i string my IF statement together to gather this and run for all options (we have 4 course options)? Is there a better way to do this?
Help Article Resources
Check out the Formula Handbook template!