Create a list based on set of values

BarneeL ✭✭
edited 12/09/19 in Formulas and Functions

Hi there,

If, for example, I had a stock list telling me how many of certain T-Shirt sizes I have left vs how many have been ordered. How could I use that to return the sizes, in text form, of those which I don't have enough of.

See attached image for example.


In this example, I would want to automatically generate a list that reads "XXXS,XXS,XXXL,XXXXL", as these values are negative.


Screenshot 2019-05-23 at 12.47.25.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!