Formula if check box is checked, run one formula, if not run another formula

aneves

Hi! What’s the best way to write that in a Smartsheet formula?

If the checkbox is not checked, I want to do this:
SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours] - [Holidays]

If the checkbox is checked, I want to do this:
SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours]

Thanks

Darren Mullen

@aneves you could simplify this some, but for sure the following would work

if([check box column name]=1, SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours] - [Holidays], SUMIFS({Column 1}, {Name}, Name@row) - [OOO] - [Hours])