Welcome!

Can you create Duplicate Cell and linked to original Sheet to hide original sheet's Formula?

Currently I am working to create a statistics to show all the work status counts. I am using multiple formulas in different cell. Is there any way to hide the formulas OR create a duplicate linked sheet where the duplicate sheet will update at the same time when I will change anything to my worksheet( Main sheet, that I am using as a reference sheet for my formulas)

Pease let me know if I can clarify anything.

Thanks in Advance!

Find more posts tagged with

Comments

Andrée Starå

Hi Rafsun,

You can cell link to another sheet or another cell in the same sheet and that information will update at the same time as the main data. You could also show the information in a dashboard.

Would that work?

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Rafsun Royal

Andrée Starå

I have tried that but the only problem is the new linked sheet also shows the formulas in I click any cell.

Is there any way that, I can just view the data but not the formulas.

Thanks Much!

Rafsun

Sign in to join the conversation!

Quick Links

Trending discussions

Highlight changes icon, print icon and view option no longer appear in published sheets
I have a number of published sheets, and in recent weeks the bar just below the sheet name, which contained the print icon, the view drop-down menu and the highlight changes icon have disappeared. I haven't done anything on the back end to the underlying sheets. Unfortunately I've put a ticket in for support help (on about…
How to avoid duplicate entries while submitting from forms
I want to restrict the duplicate entries in the sheet based on some column value conditions, I can be able to highlight the column but is there any direct method for avoiding duplicates.
Smartsheet Support Issue
I'm currently having issues with my Smartsheet environment. I pay $72/mo for 3 licenses when I only need one, yet when I have issues my support ticket has remained open for 2 weeks without being assigned. I've looked for help within the community, however when I posted my question a simple response by a random user marked…