Smartsheet Basics

Archives for March 2021

Anyone know what this balloon means?
Today we noticed a "balloon" on one of our entries: We have no idea how this appeared? This cell is populated from a Form the clients complete to receive a Covid vaccine. The history shows that a client entered his number and there are no other changes to the field. Any ideas?? Stephanie
Export to Excel, export all attached files on the rows
Hi We used Smartsheet to track test cases and test results. About 95 rows have attached Word documents with screen shots from the testing. We can export the sheet contents, but is there a way to export all the attached files also? If yes, does it reference the row to which they were attached? Thank you, Bob
Grabbing a date and time from a form
Hi there, It is easy enough to create a date field on a form. Is it possible to add a date and time field? Obviously, I could use free text but that is not as clean. Thanks!
I am looking for The Tracking/Rollup templates with an Intake process for multi project tracking
This statement was a response to question last year, I downloaded the template and deleted after "playing around with it" and wanted to restart fresh, now i can't seem to find it. The Tracking/Rollup templates have an Intake process which you will need to use to link the individual projects back to the portfolio view.
Forms Stopped Receiving Responses on 3/26
Hello, I have a form that has been working flawlessly for over a month. On 3/26 the form stopped receiving responses. Here is what I"ve checked: Filters are off Form is active There is no new automation that would move data. The only one set is one that copies a row to a backup when added -- and it has not been modified…
Form Emails
I have an automated email set up to notify certain individuals when a form has been submitted. This email shows the columns and information entered line by line so that the receiver of the email can easily read this information. This has been working fine until a user submitted two forms one right after the other (probably…
Card View by "Assigned To" does not show up when multiple people are assigned a task
Multiple people can be assigned to a task using this method: Once this is done, however, you will not
Card View by "Assigned To" does not show up when multiple people are assigned a task
Multiple people can be assigned to a task using this method: Once this is done, however, you will not be able to view by "Assigned To" in Card View. Is there any solution to this?
Time formating
I would like to know if It's possible to format a field in hours and use formulas to calculate the difference between Finish and Start and to sum...
Not able to Group a Report Using Fields in the Report
I have created a report and it's not letting me group the rows by PQE even though it's a field in the report

Trending in Smartsheet Basics

Attachments and Row Locking
I'm admin level on all of our sheets, so it's sometimes hard to test out user-level features. Can anyone let me know if users can add/delete row attachments after the row has been locked?
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
Report Question
Bringing this to the community before I jump in to try to figure it out because you are all so helpful and smart. If I have a report "Tracker C" whos filter brings in projects which have content in a comment field called "comments". I remove comments when I want a project on Tracker C to come off of the report. I want to…

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

Watch video

Smartsheet Basics

Discussion List