Hi, I use CONCATENATE and TEXT functions to create text. How can I pad spaces to the left something like LeftPad(" ", Text(number_column), 14)? Thank you!

Hi, I have a Table A and child table B, Column2 is a list of data in Table B. How can I create Column3 to list the sum of columns in Table B? Thanks! Table A Column1 Column2 Table B row1 price1, price2, price3 Table B row2 price1, price2, price3 Colu...

Column POPS is a list with filter on SpreadSheet A, I can add many records, save them to SpreadSheet B. Column COST is a list with filter on SpreadSheet B. The problem is, when I add a record to POPS and save data to SpreadSheet B, I expect the data ...

Hi, I have a table view with column width set to Narrow but got date cut. How can I show full yyyy/MM/dd? Thanks!

Hi, how can I create a chart like this with right column with one of my data columns showing Rate (the red line)? Thanks! My data looks like Date ValA ValB Rate 2020-02-01 45000 30000 0.05 2020-02-02 45000 29000 0.09 2020-02-03 45000 30000 0.13 2020-...