How to consolidate a document that has blanks
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?
Answers
-
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
-
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?
-
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)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!