My issue is pretty simpel I think. How can I make a formula that checks for the lowest value in certain fields and inserts the name of the fieldname corresponding with the lowest value. Also, then, how can I insert the corresponding value in another ...
Thanks you for thinking along with me! That indeed makes the lowest price visible, but for me it is important to know the name of the lowest vendor and corresponding price; for this reason:
On another tab where the ingredients are in, I want it to s...
I came across another issue regarding this formula.
When the field is empty, it shows the name of that empty field. Sometimes I don’t want to put any values for a certain vendor for the item. Is it somehow possible to exclude empty fields in the form...
