Smartsheet Basics

Archives for June 2018

Smartsheets Project Management newbie
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 minutes long. Thanks
Joining 2 columns
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 for the help
Sum of Cells in different Rows
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
Question - Dependent Fields
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 companies/users? Can groups control that?
Change Control form for I.T.
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?
IOS app changes cause values to become hyperlinks on export
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 "http://other/". It makes the exported spreadsheet confusing with a bunch of hyperlinks in it that do…
Using a COUNTIFS formula if date criteria is met
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 would like to use the same formula and add onto it another function which will make it more…
Cell Linking
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.
"Sticky Notes"
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/completion date would be super helpful. Thanks.
Export to Google Calendar although no longer syncing from 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 would like to export all entries into Google Calendar but not have it synced, meaning if I…

Trending in Smartsheet Basics

Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…
Removing Duplicates while also adding together values from other columns
I have a bit of a complex situation. My company uses SAP for purchasing and we pull an open order report weekly to keep track of each of the buyers orders and delivery dates. I've recently set up a Data Shuttle so we can transition from manually editing the report in Excel to a more fully automated report in Smartsheet.…
Workflow Notifications (Alerts)
The Manufacturing department in my company created a sheet to track requests related to downtime. I was asked to set up several workflows. One of these workflows is to notify the Head of Manufacturing and his direct reports whenever a new request has been submitted or the status of a record changes. These alerts are sent…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List