I've finally convinced management to let me build some decent apps with SharePoint Online. I am trying out the stock issue tracker and I have a question about Column Validation.
We have a column called Error. My boss asked if we could make a formula that if the Error is "Backorder", then make the Column called "Cost" (which is a currency field) to = $0.00.
I've tried to research proper formula building but can't make much sense of it.
The column validation option is under lists and advanced...and looks like this:
I've tried this but it said I can't change another column:
Any tips or suggestions? Thanks...