How to create the function

Hi all, I need your help.

I wanted to create an auto-calculation for the value payable in (Co broke payable) column, when [commission status]@row)=” Co-Broke Fee Payable

However, I also want the calculated value to stay reflected in the (Co broke payable) column, even after I have change [commission status]@row)=” No Pending Issue”..”

Below is what I have tried but fail.

=IF(OR([commission status]@row)=”Co Broke Fee Payable”,[commission status]@row)=”No Pending Issue”,[SIN Commission Received]@row*[Co Broke %]@row,0))

Million thanks in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!