Formula Help
I am trying to write a formula for a new field. If [ships in 7 days] a formula field is "yes", then display the number in [pallets outbound] if not, display 0. here's what I have -- not sure ...
Forum Discussion
How about this:
If([Ships within 7 days?] = "yes", ToString([Pallets Outbound]), "0")
If([Ships within 7 days?] = "yes", ToString([Pallets Outbound]), "0")
- How about it? Explain why.
- OP>I am trying to write a formula for a new field.
In the event the OP wanted a text result. - ToString is actually not a published Quick Base function.
It seems to revert to ToText though upon saving. - Then you have to do some more jazzy stuff when the OP wants to perform math on your text result.
- Oops - my bad. I had my Service Worker turned on that converted ToString() to ToText().
- It is Magic: ToString() => ToText()
