The current formula I have that works for calculating Labor hours is below
=IF([Actual Duration in Hours]@row = 0, ([# of Staff Needed]@row * ([Baseline Duration in Hours]@row * 18)), ([# of Staff Needed]@row * [Actual Duration in Hours]@row))
The issue with this formula is the labor hours are always calculated even if the task is not performed which causes errors in my total labor hour reports for a sheet.
I would like to improve this in my sheet by first including IF([Status]@row=Skipped,0, followed by the above formula.
=IF([Status]@row=Skipped, 0, ([Actual Duration in Hours]@row = 0, ([# of Staff Needed]@row * ([Baseline Duration in Hours]@row * 18)), ([# of Staff Needed]@row * [Actual Duration in Hours]@row))
This just gives me an error
The goal is if status is skipped then the formula will= 0, but if the status is anything else then calculate the labor hours based on expression IF([# of Staff Needed]@row * ([Baseline Duration in Hours]@row * 18)), ([# of Staff Needed]@row * [Actual Duration in Hours]@row)) (IF/Then this, but if not then this Formula if that is a thing?)
