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

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List