Smartsheet Basics

Archives for December 2022

Drop-down arrows disappearing from cells
I have a smartsheet I have been using for the past 8+ years. Suddenly in the last couple of months, columns I have set up to be a drop-down list no longer show the arrow you click on when you click in the cell to open up the list. Sometimes the problem goes away for a little while after the computer has been restarted, but…
Does anyone have recommendations to moving sheets to another company's instance?
We have several partners who also use Smartsheet and may want to consolidate work under one Workspace. Any advice? I don't know if you can simply "Make an Owner". Thanks in advance!
Moving Rows Between Sheets No History for Cells
I just tested moving a row of information to another sheet and the history for the cells was not available. It only showed my information as of the date moved. Has something changed? Thanks
Inconsistent Conditional Formatting
Hey Community! I'm wondering if someone can help me out with why conditional formatting is not giving me consistent results. As shown below, I would like to see red text when the Unbilled column is not zero. One section is returning red text for $0.00 and another section is leaving it black (which is what I want). The 3…
Is there a way to link attachments across sheets?
I have attachments on rows in one sheet. Right now, I download that attachment and upload it to a row in a different sheet. Is there a way to link the attachment so that when I put it in Sheet 1, it will appear in Sheet 2? Other than downloading and uploading it of course. Thank you for any insight!
Formula for Dates Calculation
Hello, I am trying to find out how I can create formulas for the below. Kickoff Date - Number of rows with a kickoff date by month? IE Count of projects in a column with a kickoff date in Jan, Feb, March etc Average days in IMPL - The average number of days for all projects. IE: kickoff day in my sheet vs current day for…
How to Create a Contact List entry from Name and Email form fields
Is there a way to create a Contact List entry in a column based on 2 different fields? I am trying to gather data for a sheet via a Form. Ultimately, I want to have a Contact List field for each entry, but Contact List fields in Forms only show up as text fields. Am I missing anything there, or is that how it works? So, if…
Form: Change "From" on Automated Form Submission
Hello! My team at work recently created a form with an automated email response to confirm to the recipient that their submission was received. When this email is sent, however, it reflects the name of the owner of the sheet. I am wondering if it is possible for us to change the name to something generic for our team,…
Automated Workflow - Alert only specific email addresses
We want to reduce the amount of notifications that consultants receive. However, the clients would still like to get notifications. Is there any conceivable way in a multi-select contact column to restrict notifications to only specific email addresses? To clarify, is there a way to restrict notifications (alert…
Is it possible to retrieve a sheet containing the exact details from an specific date?
I accidentally replaced with new information the sheet that should not be changed. After a month, I was requested to restore the original data from October 2022. :(

Trending in Smartsheet Basics

Australian User Access to Smartsheet Templates?
Hi, I keep getting bounced around by Smartsheet when trying to access the pre-existing smartsheet templates?? I am not located in America or Europe (I'm in NZ but my plan is billed under Australia). It would save me a LOT of time if I could access these again. I have a Pro plan. thanks H
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I have a Pro plan but I cannot create ANY reports
I have a Pro plan but I cannot create ANY reports. The system does not allow me to choose a folder, and consequently a sheet to create a row report and suggests an upgrade to Business or Enterprise. I'm quite new to Smartsheet and feel a bit disappointed with this limitation, or maybe I'm just doing something wrong. Alberto

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

Watch video<

Smartsheet Basics

Discussion List