Using Smartsheet

Discussion List

• Smartsheets Project Management newbie

  In Using Smartsheet

  I am new to Smartsheets and new to project management. Is there a smart sheet course that I can take that caters to a project manager in training?  The videos I am finding are not quite descriptive enough for me and are only about 5 minut…

  LorraineRamos

  11 1

  11 views 1 comment 0 points Most recent by Andrée Starå 06/30/18Using Smartsheet
• Joining 2 columns

  In Using Smartsheet

  Hi, i need to join 2 columns. First column is the City Name and second is the Numbers. I got it to work but I only need the first 3 digits from the City : =JOIN(City1 + Number1) comes out CITYNAME3462 I need to show up CIT3462 thank you …

  Patricia Worth

  11 2

  11 views 2 comments 0 points Most recent by Patricia Worth 10/02/18Using Smartsheet
• Sum of Cells in different Rows

  In Using Smartsheet

  Hi Is it possible to sum the counts of specific cells on different rows in the same sheet.All the cells are in the same column. Thanks Mcneil        

  McneilOMC

  483 4

  483 views 4 comments 0 points Most recent by Andrée Starå 10/03/19Using Smartsheet
• Question - Dependent Fields

  In Using Smartsheet

  We have a few questions:   * When our users are entering data in a form, is there a way to default certain fields based on other entries? * When users enter data, we only want them to see their submissions and not those of other companie…

  bzamborski

  81 2

  81 views 2 comments 0 points Most recent by Paul Newcome 06/29/18Using Smartsheet
• Change Control form for I.T.

  In Using Smartsheet

  I'm looking for a change control form with workflow for approval. It should be tailored  for I.T.  Surprisingly I can' seem to find one in Smartsheet. Does anybody have a good one?    

  Chadwick W

  2 1

  2 views 1 comment 0 points Most recent by Andrée Starå 06/29/18Using Smartsheet
• IOS app changes cause values to become hyperlinks on export

  In Using Smartsheet

  In the past month or so, when I make changes to data in a sheet using the IOS app, those changed values become hyperlinks to the word.  For example, if I change a cell value to the word "other", it makes the value in Excel "…

  ScottW

  11 1

  11 views 1 comment 0 points Most recent by Shaine Greenwood 07/03/18Using Smartsheet
• Using a COUNTIFS formula if date criteria is met

  In Using Smartsheet

  Hello smartsheet community,    I am having some serious difficulty getting a COUNTIFS formula to work based on if a row in another sheet meets a data criteria.   My COUNTIFS formula works right now when referencing another sheet, but I…

  mwiggins

  82 2

  82 views 2 comments 0 points Most recent by mwiggins 06/29/18Using Smartsheet
• Cell Linking

  In Using Smartsheet

  Hi Everyone, Is there such a thing as an "if" statement then link cells? If cell has check mark link these cells to a different sheet.

  Jgrinde27711

  1 3

  1 view 3 comments 0 points Most recent by Paul Newcome 07/02/18Using Smartsheet
• "Sticky Notes"

  In Using Smartsheet

  Any update on adding virtual "sticky notes" to an SS? This was discussed back in 2016, but maybe there has been some movement? For example, a "sticky note" to a page to update viewers that the page is being edited w/co…

  tross

  32 2

  32 views 2 comments 0 points Most recent by Andrée Starå 06/28/18Using Smartsheet
• Export to Google Calendar although no longer syncing from smartsheet

  In Using Smartsheet

  Question- We would like to export the calendar to Google Calendar. I am familiar with the publish feature but it appears that it will only create a new calendar and can't be added to an existing Google Calendar.  1. Is this correct? I wo…

  SS IT

  1 1

  1 view 1 comment 0 points Most recent by Shaine Greenwood 06/29/18Using Smartsheet