Not sure about a random number generator within the app, but using my Currency example, you could add a column for quantity and have the following formula in each Item row of that column. The items would have an ever changing quantity. If you change your sheet to recalcuate every minute or every hour, then the numbers will continuously change. =randbetween(1,5)