linking cells within the same sheet

I am trying to create a star or check box on my sheet that automatically checks if another cell has a "yes" answer. This would be super helpful and I see a lot of requests for something similar in the community.

Please consider adding this function

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Genevieve P.

Hi @LindseyJ

There are two possible ways to do this right now:

You could use a formula to look at that cell for "Yes" and then check the box if it's true. This would be a column formula though, so you wouldn't be able to manually check boxes in other rows.
You could use a Change Cell workflow to automatically check the box when "yes" is in the other cell. This would allow you to update other rows manually, too.

Is there a reason either of these options won't work in your scenario? It would be helpful to know more information!

Thanks,

Genevieve

wlynn

this would minimize the need to scroll!

user818

Adding another vote to the cell linking within the same sheet. Forum linked below.

Can you cell-link within the same sheet? — Smartsheet Community

Sidtomar

I want to have a summary section to pull important tasks and % completion that requires linking summary section to respective tasks somewhere down and a cell to cell linking on same sheet will help. ty!

KColvin_civic1

Please create something so we can cell link within the same sheet so when you click, it just jumps to the needed cell.

Quick Links

Trending ideas

Alternative to unnecessary browse button change
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
Backup all workspaces
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
Fix API documentation for "Alternate Email addresses" and improve Bad Error Messages
I had Technical Support Case #09045069 in relation to this issue. I was told to get the API documents corrected, I needed to post to here. Update API Documentation Some (all?) of the API calls related to Alternate Email Addresses require both an Enterprise Account and to be manually activated by Smartsheet Support. The API…