How to consolidate a document that has blanks

Stefano Ferretti

Hi,

I have a grid I stored comments on questions from customer. some question may not have been answered so it results in the cell being blank.

I would like to get to another document where all the available answers are consolidated, with no blank cells.

Below a screenshot of an example document.

so ideally I would like to end up in a situation like the below

Any idea?

DanS

An idea is to use Smartsheet SDK (Smartsheet Developers) . Psuedo code

From column -- Comment1 to Comment3

From row -- Pippo to Caccola

If the current cell -- cell(row, column) -- is blank, go to the next column to find a non-blank value, if any, until you find a non-blank value, or you arrive at the last column (Comment3)

then iterate to

Next row,

Next column

Stefano Ferretti

Hi @DanS ,

I've never used the SDK, but i'll take a look.

is this a free module? or does it require additional licensing?

DanS

It is free, but will require knowledge in writing scripts. For my projects, I use Smartsheet's Python SDK - smartsheet-platform/smartsheet-python-sdk: Library that uses Python to connect to Smartsheet services (using API 2.0). (github.com)