Smartsheet Basics

Archives for January 2021

Task Automation Question
How can I automate when a task is assigned from another user to automatically add to my sheet?
Best Practices for managing 60+ projects in Smartsheet
Hello, I am a fairly new user of Smartsheet and have recently started at a construction company as a project manager where we design manufacture and erect large steel buildings for rural and industrial use. (From farm sheds through to aircraft hangers and fabrication workshops.) We have up to 70 projects active at any one…
I would like the default value for date in a form to be now. Example: Today(), Now(), etc...
The default value in a form to be today(), now(), etc...
Form integration with proofing
Hello, I work for a CPG company and we have a checklist we want 4 different departments to check when they are asked to proof apart form other observations or comments they might have. It is important for us that everyone checks these boxes to avoid any legal errors with the packaging in the future. For this purpose I…
Can I use a Join when trying to create a report from 2 sheets
I want to "Join" the data from one sheet to the other sheet in a Report using the Primary Field so that I only get 1 ROW with all the columns filled in. Instead, I get DOUBLE primary each with data populated only from the Sheet it came from which isn't useful at all. Is this possible?
Comments on row using Comment vs Cell comments and reading through cell history
Good day Smartsheet community, I am trying to see how everyone else is managing progress/next steps for each task or action. Are you all using the comments function or do you have a row and just type up comments and right click Cell History when you want to read what has transpired? Hoping to get best practices. Thanks,…
Can I set sheet to show the sheet summary when a user lands on the page?
I'd like to display the sheet summary when a user lands on sheet, and keep the summary open until a user dismisses it.
Column Character Limit
I am looking for a way around the 50 charcter limit in the column headers. I have a sheet that sends out update requests monthly to various team members and the headers are questions they are required to answer. I am having a difficult time paring down my questions to 50 characters. Any ideas on how to get around this? I…
Basic Automation flows not working
I cannot for the life of me figure out why the most basic automation tasks are not working. I have checked my permissions and I should be getting notifications, but my workflow seems to work very sporadically. I want the email to be sent to the PM when the "helper box" column is checked just so I can see what the email…
Making mandatory an update request in automation workflow
I would like to know if in an automation workflow is it possible to make it mandatory to modify or change a column data or field in the request before making it complete. I have set a Field of the status of Our customers, and in a certain moments I need our sales team to update some columns,... I did a workflow to send…

Trending in Smartsheet Basics

Form Submissions aren't appearing on the sheet!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
Why is my report suddenly blank?
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
Submissions
39 submissions isn't accurate because many of them were just tests. Currently have 3 submissions and would like for it to show 3, is that possible

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

Watch video

Smartsheet Basics

Discussion List