Cell linking

Discussion List

  • How do I make a Smartsheet that keeps track of initials
    In Using Smartsheet
    I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many …
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Remove a dropdown option , if it is already selected
    In Formulas and Functions
    Surprised, this does not exist yet in smartsheet. I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable. I am…
    Answered - Pending Review
    33 5
    Answered - Pending Review 33 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Enable Datalink from other Smartsheet for Dropdown list (for Multi and Single Selection)
    In Using Smartsheet
    Dear Sir/Madam, Kindly request you to add or enable datalink option in Dropdown list which helpful smartsheet users to update the Dropdown data in one place and utilize it all dropdown list. Thanks for prompt support. Best regards.
    Accepted
    25 3
    Answered ✓ 25 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Send alert to task's assignee when predecessor task's status changes to complete
    In Formulas and Functions
    Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee …
    453 5
    453 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Turn Cell Formula into Column Formula
    In Formulas and Functions
    Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the formula down, it works. However, wh…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • JIRA Sync To Smartsheets Not Syncing
    In Using Smartsheet
    The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually…
    Answered - Pending Review
    38 1
    Answered - Pending Review 38 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Reference Sheet CountIfs Formula
    In Formulas and Functions
    Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk…
    Answered - Pending Review
    48 4
    Answered - Pending Review 48 views 4 comments Most recent by David Tutwiler Formulas and Functions
  • COUNTIFS
    In Formulas and Functions
    I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks
    Answered - Pending Review
    25 4
    Answered - Pending Review 25 views 4 comments Most recent by lukasrobbo97 Formulas and Functions
  • Dynamic Production Date Schedule
    In Using Smartsheet
    I work for a small company who manufactures kitchens in Oxfordshire. We are able to make 9 kitchen units per day, 4 days a week - so a kitchen that has a total of 27 units would take 3 days to complete. As there are many external factors t…
    Answered - Pending Review
    34 1
    Answered - Pending Review 34 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Need some suggestions with highlighting info on a tracker
    In Using Smartsheet
    Hello everyone, I am looking for some creative support with a sheet that compiles milestones and dates from other trackers to an aggregated sheet with linked cells. The purpose is to share dates/milestones for each project with each column…
    Answered - Pending Review
    56 2
    Answered - Pending Review 56 views 2 comments Most recent by Genevieve P. Using Smartsheet