Forum Discussion

RoxanneZiegler's avatar
RoxanneZiegler
Qrew Cadet
4 months ago

Formula help

I currently have this  If([Tour - Salesroom]= " Solmar-New", [Sales Manager]= "Mark Torontow",[Sale - Purchase Price]*ToNumber([Sales Manager Point])/100  first I am getting a yellow notice at end ...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 months ago

A text or numeric formula in QuickBase is similar to Excel, in that it performs a calculation.  It does not set the value in fields.

 

i suggest that you explore using Form Rules to populate certain fields based on the Tour Type And the sales points rate.