How to list columns from a grid and a report ?

Hell All,

I'm looking for a way to extract info in a table showing which grids and which reports are unsing which columns, every day or every week.

I tried several things but first I would like to give a list of grids and reports concerned.

Then I would like to extract their "structure" and put all information a a single table.

Thus, I could see where a column "A" is used.

Moreover, the best thing would be to also have the type of the columns ("date", "symbols and which ones", "dropdown list" and the list…)

I'm sure a lot of people need that too and I hope you will be able to help me.

Thanks a lot !

Aurelie

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141348/how-to-list-columns-from-a-grid-and-a-report

Hi,

I hope you're well and safe!

Can you elaborate?

Please share some screenshots and/or additional information. (Delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Aurelie R.

Hello Andrée

Sorry my first message was empty !!! I pasted details…

Andrée Starå

https://community.smartsheet.com/discussion/comment/490923#Comment_490923

No worries! Easy to miss!

Do you have access to Data Shuttle?

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Aurelie R.

Hello

Yes I have and I began to practice to save tables or to extract some data (it works).

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.