Copy , move or share selected cells / information with others

Hi All

How to copy/move or to share rows to another sheet with column of my choice .

or to share some cells / columns of my choices with others but not all row information

The reason is i donot want to share some information with others

Im doing it with trick like to send to landing sheet with some automated actions to approve new triggered and added rows changing stats to 0 or etc that later to be forwarded to the final landed sheet etc

Its long tricky flow that im trying to make it in easier way

Find more posts tagged with

Sharing and Collaboration

Automations

Conditional Formatting

Importing and Exporting

Accepted answers

All comments

Paul Newcome

You could just build a report that will show the columns you want shown and have it filtered to only show the rows you want. If you publish the report and send the other person the published URL, they will not even need access to the source sheet to be able to view the data.

Leibel S

@Waleed

You can also make an automation that copies to a second sheet.

In that sheet any column you do not want anyone to see simply change it to a column formula like ="N/A" and it will override any data coming in...

Waleed

@Leibel S

How to do the override automation ="N/A" ?

Also , it will be seen in cell history ?

Leibel S

Write a formula into a cell of that column then right click and hit convert to column formula.

The formula can be anything it can even be =""

The value from the previous sheet does not show in the cell history.

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, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.