Dear Smartsheet Wizard,
I'm trying to create a function but I'm running into an error.
The IF - And function I'm creating basically needs to do the following:
If salesperson 1 is = "Yan" then deduct 100 from Profit and his commission should be profit*0.5. Otherwise, deduct 100 from Profit