Smartsheet Basics

Archives for May 2021

Assign People Automation
Is there a way for this workflow to notify the person when they are assigned?
Enhancement Request: Sheet Name on Update Requests
I've searched and haven't seen this topic posted yet. Our company has hundreds of individual projects running simultaneously, so when I send an update request to an individual there is no indication which project the request is referring to. I realize that I could add a column that is populated with only the project name,…
Attachment appears in search but not on the sheet?
I have an attachment that I am able to find when searching in Smartsheet. I can click on it to view in the search box but I cannot locate it on the actual sheet. I reviewed the activity log for the sheet and see where the attachment was uploaded however but I cannot find any activity log entry that says it was deleted. I…
Put two fields from a report on a dashboard, and just those two fields, no column headers
I have a dashboard that shows a bunch of information about upcoming publications. Things like who is contributing, submittal deadlines, approval deadlines, etc. I have sheet with the publication date in it. I want this date to appear at the top of the dashboard. Literally something like: Publication Date: 05/11/2021 Is…
Resources_Holidays and holidays
Bonjour, Je débute dans l'utilisation de smartsheet et c'est mon premier message sur le forum. Voici mon problème. J'ai des ressources et des projets. A mes projets j'affecte une ou des ressources. Je peux attribuer à mes ressources des congés et ils apparaissent sur le planning spécifique à chacune de mes ressources. Par…
Hiding Blank Reports on a Dasboard
I have project level executive summary dashboards that have a number of reports on them that quite frequently have no data - Open Issues, Escalated Item, etc. Is there any way to hide / remove the widget when the report is empty. It is not the best looking report for an EVP to look at when it shows a heading "OPEN ISSUES"…
Will inserting a new column break references?
I think I know the answer, but my colleague wants a little more reassurance; She has a data sheet, and this data sheet feeds a number of single cell reference metrics to a dashboard. She wants to add a new column of data to the initial sheet, but is concerned that it will break the references the metrics use. I hvave…
How can I remove BLANK value from Star rating field?
Hi Team I need to show only One to Five ratings, and so I need to remove the EMPTY value - how can I do this? Thank you!
I don't get attachments in the Emails
Hi, I don't get attachments of the file if someone has filled up a form and submitted it to us. All the time I have to go inside smartsheet and check. Can I have this been sent on email to please.
Smartsheet Company Wide Training
I am trying to find any training material that Smartsheet has that I can leverage for company wide training. I will be organizing our training/implementation/roll out plan to ensure all necessary employees understand the tool and can hit key milestones within Smartsheet. I know they have lots of training videos, but just…

Trending in Smartsheet Basics

Calculating % of completion based on start & End dates
I'm looking for a formula that calculates the % of completion based on start and end dates
Dynamic Chart
I'm trying to create a dynamic chart that shows a number count for the past three months. I figured I could set conditional formatting to change the font or row color based on the date but is there a way to pull (only those with the color) into a metric sheet to create a graph? Or any other way going about that?
Having trouble populating a contact list column (Auto-provisioning is not enabled)
I understand the ultimate solution if I want all employees in a contact list is to enable auto-provisioning. Our IT department isn't ready to do that yet. In the meantime, I have searched help and the community and can't figure out how to solve the problem. I need the contacts not in "my contact list", I need them as…

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

Watch video

Smartsheet Basics

Discussion List