Project Management

Discussion List

  • How to get a notification when only certain users have modified a sheet
    In Using Smartsheet
    Hi, I'd like to setup a workflow to get an alert but only when certain people have made a change to a sheet (around 75% of the users who have access to the sheet). I tried to setup a workflow to look at the 'modified by' column, hoping I c…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Filter tables based on dropdown menu selection
    In Formulas and Functions
    Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustra…
    Accepted
    21 3
    Accepted Answer 21 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Error when opening a sheet
    In Using Smartsheet
    As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it does…
    164 6
    164 views 6 comments Most recent by bvick Using Smartsheet
  • My average formula is disappearing....
    In Formulas and Functions
    Hi SS World...very basic user here trying to determine the average of children rows in the parent row. Tried using 2 different formula's in the parent row (white row): =AVG(CHILDREN()) =SUM(CHILDREN()) / COUNT(CHILDREN()) The average w…
    Accepted
    32 9
    Accepted Answer 32 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • Row height issue
    In Using Smartsheet
    I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or changed the text positioning but the format…
    1052 4
    1.1K views 4 comments Most recent by Joost Using Smartsheet
  • Timeline end date not updating correctly - help needed
    In Using Smartsheet
    Hi, I'm having an issue with my end date at the top not updating correctly. I have all the subtasks below indented correctly; however, it will not reflect that at the top most level. Please see the photo attached. I added in a new line at …
    Answered - Pending Review
    21 4
    Answered - Pending Review 21 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Zero Formula
    In Formulas and Functions
    Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much. 
    Answered - Pending Review
    1395 31
    Answered - Pending Review 1.4K views 31 comments Most recent by Paul Newcome Formulas and Functions
  • Linking directly to files from a dashboard?
    In Using Smartsheet
    I understand there is no way to link directly to a file from dashboard unless it is in a cloud-based storage program. Has anyone found a workaround? We don't use this kind of storage and I want to be able to link directly to files.  Savin…
    3031 14
    3K views 14 comments Most recent by Caitlin Swim Using Smartsheet
  • Use DISTINCT with COUNTIFS
    In Formulas and Functions
    Hey Guys! I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!!  So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) …
    834 5
    834 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Index Match Showing Incorrect Amounts - Formula when there is no information to pull
    In Using Smartsheet
    Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as &q…
    Accepted
    31 12
    Accepted Answer 31 views 12 comments Most recent by Genevieve P. Using Smartsheet