Using Smartsheet
Archives for June 2018
Discussion List
-
Smartsheets Project Management newbieIn Using SmartsheetI 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…
-
Joining 2 columnsIn Using SmartsheetHi, 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 …
-
Sum of Cells in different RowsIn Using SmartsheetHi 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
-
Question - Dependent FieldsIn Using SmartsheetWe 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…
-
Change Control form for I.T.In Using SmartsheetI'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?
-
IOS app changes cause values to become hyperlinks on exportIn Using SmartsheetIn 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 "…
-
Using a COUNTIFS formula if date criteria is metIn Using SmartsheetHello 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…
-
Cell LinkingIn Using SmartsheetHi 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.
-
"Sticky Notes"In Using SmartsheetAny 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…
-
Export to Google Calendar although no longer syncing from smartsheetIn Using SmartsheetQuestion- 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…