set time

Hi,

=IF(Processtype@row = "Fast", Starttime@row + 30, IF(Processtype@row = "Long", Starttime@row + 60, IF(Processtype@row = "Large", Starttime@row + 120, "Not Proper process Type")))

Actually i would like to do, if procees type Fast ,, add 30 min more with starttime, Long means 1 hr,Large means 2 hr,,

can anyone pls help me to fix the problem...

Thank you for your help,

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!