Filtering by Cell Links

In our workflow, we rely on cell links to populate data from separate team sheets (SS Logs) into a master sheet. Currently, when filtering our linked "Last Contact Date" column for blanks, the filter includes:

Cells that are blank and not linked
Cells that are linked and the source cell is blank

This makes it difficult to isolate the rows that still need to be linked. For example, in our main sheet with over 1,200 rows, I’ve filtered down to the relevant categories, but I’m still seeing over 100 rows when only around 40 actually need links.

I would like to request a filter to check whether a cell is linked so I can isolate linked or not-linked cells.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Cell linking

Filters

Comments

There are no comments yet

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.