Smartsheet Basics

Archives for October 2018

Formula needs to be removed from Published reports
The formula is appearing on a particular sheet published report. This reappears after refreshing and saving the sheet. Please help :)
System: Created By as Contact List?
I have a form that's only accessible to registered Smartsheet users. I believe that means that the System: Created By field will always be an email address. In that case, is it possible to use the System: Created By column as a Contact List for things like Notifications and Update Requests? That would be more efficient and…
Is there a way to auto-fill across the header?
Hi there, Is there a way to auto-fill across the header? For example, if I put the very first date and then add a formula to add 7 days across until the end of the project? Or do you have to manually enter each header? I am trying to find an easier way to update template headers. Thanks, Jill
How to use Forms for populating Sheets
I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release the use of the demo unit (i.e., make it available for others to use it) as well as…
Rollup percentage in project schedule template is not calculating correctly
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
Hide / Show Columns
It would be really nice if Unhide ALL wasn't the only option. I print info for several different people and some of the columns need to be seen by some but not all. I hide alot of columns so unhiding all just to change a couple is a total pain and alot of waisted time.
Restricting cells to numbers only
I noticed there's a way to restrict columns for most column types except Text/Numbers. I want to only allow numbers to be typed in and not letters because when letters are typed into those cells, it messes up all my formulas. More specifically, I'd like the editors to only be able to type in a range of numbers, for example…
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
Alerts are not working
Hello! Today we have discovered that alerts in one particular (the others are working just fine) sheet are not working. I have tried few tips from the discussions but they don´t seem to be working at all. I have tried to check my spam file in email, even have enabled "Include my changes in sheet notifications"... Nothing.…
Simple method to make a Gantt chart on Smartsheet
A simple method to make a Gantt chart on Smartsheet

Trending in Smartsheet Basics

Generating a Report based off Filter Criteria
Hi All, I am attempting to generate a report off of a filter criteria in the main sheet. It is is a live document and we work off specific filter criteria's per person, but I want to generate a report based off the circled "Current Renewals" only, but when I go to to generate the report, the report takes all historical…
same columns appear in multiple sheets
Hi I want to know how I copy some columns from master sheet to another slave sheets and, also slave sheet should follow the modification done to the master sheet simultaneously.
Require a field to be filled before a certain value in another can be selected
I would like to require that a couple of fields ("Root Cause" and "Resolution Notes") in an "issue tracker" sheet that we're using be filled before the dropdown field "Ticket Status" can be changed to "Resolved". We do not have any of the add on functionality. Is this possible with a Smartsheet Business account?

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

Watch video

Smartsheet Basics

Discussion List