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.

Data Validation
Bringing this back up again... https://community.smartsheet.com/discussion/answered-how-offset-date-picker
Trouble with Nested IF Statements
I have to columns in my Smartsheet. Once column called "Activity" that is a drop-down with 10 values. Another column called "Value" where I am putting my Nested IF formula. Basically I want a number to be returned in the Value column depending upon the selection of the drop-down in the Activity column. To test just one IF…
Single Row Report
I'm incredibly new to Smartsheets (I joined yesterday) and am feeling my way around quite nicely. However, certain things are eluding me. We have a single smartsheet that contains information that we publish to a website. Each row is an indicator that gets published quarterly. What I'd like to do is to be able to produce a…
Alerts & Notifications
Is anyone experiencing issues with setting up Alerts & Actions? I have tried numerous times to create automated updates requests and they are not being saved even though it appears they are saved (by the number next to Manage Alerts & Actions.
Alerts & Actions not working
I have set up several alerts, some are working, some are not. is there any reason why one alert would work and another not? can i attach my smartsheet for you to look at?
Skype Log in issue
When I try to sign in to Skype for Business, there will be a pop up for the sign in, but it quickly goes away and tries to do it all over again. I am using Google Chrome, and there are a few more people in our office having similar issues
Full screen option for embedded sheets
Are you able to investigate providing a full screen option when embedding a sheet / report. I know I am not alone in desiring this functionality certainly it does further justice to the sheet and data when its full screen making it easier to work with and more seamless integration. Even if you were able to turn it on, with…
Working with another Project Team
I am working with another project team and we both have separate accounts for SmartSheet. How can we connect a project smartsheet through 2 accounts? Mandy
Plotting a total over time
I'm trying to do some rough and ready resource planning. I've created a column called 'Dummy resource' and I'm putting in it the number of people who will be working on the each task. I'd like to produce a plot of the daily total of this number (sum of people working on active tasks) against the date for the duration of…
Percentage Formatting
Hi All, Is there a way in Smartsheet formatting to show the percentage format out 1 decimal. For example, I am trying to how a percentage at 0.5%, but the format rounds and displays at 1% Thanks

Popular Tags

Trending in Smartsheet Basics

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…
Inform team on general sheet
Hi, Is there a way, now on a row but sheet level to inform the team whom the sheet has been shared with about modifications done to said sheet. E.g.; I have added locations to a locations column and would like to inform all sheet collaborators on it. Additionally I would like to ask some if moving forward to make a form on…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags