Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Planing a load of production
I'm trying to make sheet that I will be able to put orders, amount of planed hours on task and devide for different type of teams, employees.
I have stuck on one logic function. At the moment, when not all informations are typed in, function below returns blank cell.
=IF(ISERROR(PRORATE($[Total hours]32, $Start32, $Finish32, DATE(2017, $2, $4), DATE(2017, $3, $5))), "", PRORATE($[Total hours]32, $Start32, $Finish32, DATE(2017, $2, $4), DATE(2017, $3, $5)))
I would like to add to it also logic function, that will return blank cell if result of function is equal 0 (zero)
Do You have any idea?
Example of this sheet is available below.