imstac73
asked on
Sharepoint list calculated column value based on checkbox
Hi,
I am trying to add a formula to a calculated column I created in my Sharepoint list. If the user checks my checkbox column then the calculated value is based on another field * some numbers, if not then the value is just 0. Here is my syntax:
IF([Material Delay],([Labor (Hours)]*66)*.50),0)
Keeps saying my syntax is wrong or it is not supported. Not sure what I'm doing wrong.
I am trying to add a formula to a calculated column I created in my Sharepoint list. If the user checks my checkbox column then the calculated value is based on another field * some numbers, if not then the value is just 0. Here is my syntax:
IF([Material Delay],([Labor (Hours)]*66)*.50),0)
Keeps saying my syntax is wrong or it is not supported. Not sure what I'm doing wrong.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.