Cell linking

Discussion List

  • Can I link TO another sheet instead of linking FROM?
    In Archived 2015 Posts
    I need to link my issue log rows to a master issues log in a different workspace in SmartSheet. However, my boss does not want anybody to make changes in his worksheet unless those changes are done by linking our issue rows to it. The only…
    14 2
    Closed 14 views 2 comments Most recent by JohnHinkle Archived 2015 Posts
  • Trying to create a fancy email with status reports from multiple teams
    In Archived 2015 Posts
    I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, …
    107 1
    Closed 107 views 1 comment Most recent by JohnHinkle Archived 2015 Posts
  • Macro like functionality
    In Archived 2015 Posts
    Is there any method planned that would enable a change to trigger other changes.   For example, I'd like to be able to cut out a step in one of my sheets whereby if I mark a task as complete that it would automatically change the % compl…
    552 6
    Closed 552 views 6 comments Most recent by Jeremy Pemberton Archived 2015 Posts
  • How to reference 100's of items with corresponding triggers to designate an end date.
    In Archived 2015 Posts
    Hi -   Our agency has a formal record retention policy that lists over 100 types of records that we store or have digitized in-house.      Question to answer/example:  If the documents for Site A fall under Record category 1, they  sho…
    4 2
    Closed 4 views 2 comments Most recent by Brett Evans Archived 2015 Posts
  • Dependency between multiple RYGG cells
    In Archived 2015 Posts
    Hi,   Is it possible to create a complex dependency such that a task's status is derived from it's sub-tasks' status. i.e:           Status Task  AVG(ST1-4)   ST1    R   ST2    G   ST3    G   ST4    Y That way we could avoid manu…
    45 9
    Closed 45 views 9 comments Most recent by Elad Cohen Archived 2015 Posts
  • Advanced Cell Linking Capabilities?
    In Archived 2015 Posts
    When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics de…
    81 2
    Closed 81 views 2 comments Most recent by JamesR Archived 2015 Posts
  • Dashboard
    In Archived 2015 Posts
    I have developed a dashboard sheet that contains data from 3 different  source sheets.  Unfortunately, it requires me to manually input the data.  Is there a way to use a formluain  one sheet that relies on data from another sheet.  I know…
    23 1
    Closed 23 views 1 comment Most recent by BobbyLite Archived 2015 Posts
  • Is it possible to Auto-Fill dates?
    In Archived 2015 Posts
    Hello, I'm sorry if this question has been asked before, but I couldn't find anything through the search function...   I have prepared a template for event management.  We use the same structure for every one of these specific events th…
    3231 2
    Closed 3.2K views 2 comments Most recent by BobbyLite Archived 2015 Posts
  • Moving rows and losing formulae links.
    In Archived 2015 Posts
    Hi there,   I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the row change. I have to reapply the fo…
    14 1
    Closed 14 views 1 comment Most recent by John Hammond Archived 2015 Posts
  • Assigning Colors to Contacts
    In Archived 2015 Posts
    I use the gantt charts and calendars to make sure my contractors are not in two places at once.  Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned …
    680 2
    Closed 680 views 2 comments Most recent by Brian Kutz Archived 2015 Posts