Shortcodes are essential when using the Sheets app on an Android or iOS device, and very useful when using the Sheets web browser user interface as well.
With a few exceptions shortcodes can be entered in a blank data cell or appended to the data already in a cell.
Make sure the 'blank' cell doesn't have a formula in it
It is well worth while learning these codes. Use a training spreadsheet running in a web browser to gain familiarity and using Chartroom mobile will be a breeze.