Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Formula to track cell changes
Hi, I would like to present in report only rows which some of the cells has changed (Status, Due date, comments). Is there a formula to track cell changes? Thanks
Is there a way to easily share Sheet with all "Assigned To" contacts?
Is there a way to easily add all the contacts from a Sheet's "Assigned To" column into the "Invite Collaborators" field when trying to share the Sheet?
Link Project Management Pipeline to Key Account list
We have two sheets that need to work together... 1) One Sheet is for our Customer list. 2) The other sheet/s are for projects. Both have separate functions obviously, but need to integrate with each other. What we want to achieve is for our Sales Team who may be following up a Customer, to know of any projects that the…
UK Date Format
Hi All, Most of you know by now that since the Smartsheet outage incident there is a problem with the date formatting. I'm surprised to see that the issue was reported on the 31st July and until now (2nd August) this hasn't been resolved. Now, after resetting browser cache, cookies and personal settings on the Smartsheet I…
Task Management Best Practices/Solutions
Hello all! I'm currently designing an updated workflow and I'd love to gather some best practices/what's worked well from other users. Right now, the project team makes an update in the sheet, notes which column they changed in the "Changes" field, and then flags the row. This sends an automated notification to a partner,…
Create Contacts Automatically
If I have First column full of names and Second column with respective email ID, I want a way to create a contact automatically in third column. Please see the image below. I want to get the contact created automatically based on data from other two columns. I will explain my use case. Please suggest if there is any better…
Use of the system column to get the modified date
Hello everybody, I am trying to automate the input of the modification date of a particular cell on my sheet. I figured that since this information is already available in the system column [Modified] - I'd like to take that info to put it into another cell (with Date properties) Thanks in advance for the support Chris
Date format is wrong since the outage!
Hi, I live in Brazil and since the outage yesterday my date format is wrong. In Brazil is DAY/MONTH/YEAR but my dates are now MONTH/YEAR/DAY! I already tried to switch back and forth the regional preferences and it didn´t work.
Fiscal Quarter not displaying properly
Hello everyone. I am trying to create a calendar by quarter. Our quarters start in Nov and end in Oct. While I have designated this in the calendar....it keeps giving me 2018/2019 instead of 2019/2020. Can someone help me figure how to get the quarters to display properly? Thank you in advance. Lisa
Dependency Settings specific to each day
Is there a way to allocate specific hours on individual days e.g. Mon 7 hours , Tuesday 8 hours etc

Popular Tags

Trending in Smartsheet Basics

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags