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.

Automate update requests for every week if status is not 100%
Hi All, Is it possible to set up automated update requests until such time that the particular task is complete? What i am trying to achieve is: I have a large project involving 360 sites, i have created a sheet with 360 rows and 8 columns of status for different tasks. When a column is complete it adds 12.5% to the %…
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
Sheet Name Appearing within Google Calendar Milestones
I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the…
Formulas in Symbol defined columns
I've defined a column to use RYG. If I click on a cell in that column I get a drop down to pick from the 3 color ball options. Now I'm putting a formula in that cell that will do a calculation the picks R, Y or G. So now all is good; however, If I click on the cell where that formula is and click on the drop down list, it…
Update Request
Hello, I am not seeing the envelope in the far left column titled "i" where I normally do in my other sheets. Can anyone tell me how to fix this? All I see is the bell (see attached).
Saving Indented Row View
I love the Indent feature and especially the CHILDREN() function. Every time I save sheet or switch back from another sheet, my hidden indented rows completely expand & I have to re-click everything to find where I am. What am I missing to make sure the rows stay hidden until I need them? Thanks INB
Best way to layout sheet for multiple user data entry and charting
New to the program so am looking for some guidance to head down the right path. Lets say I have 10 different metrics that need to be updated once a week for 52 weeks. Each metric is owned by a different employee. I want them to enter their data, not send to me to enter. At the end of the day I need to be able to print one…
Cannot link a Start Date because its value is determined by a project dependency
I am trying to interleave two project plans by linking activities across two sheets. The integrated workflow should be Task 1 -- Task 2 -- Task 3. Task 1 must complete before Task 2 begins. Task 2 must complete before Task 3 begins. Tasks 1 and 3 appear on Sheet A. Task 2 appears on Sheet B. I have created links for Task 1…
ROUND Function - Round up to nearest whole number
Hello, I want to be able to round up a number to the nearest whole - for example 4.1 would round to 5, 4 would stay as 4 5.6 would round to 6. any whole numbers would not round but stay the same.
Why are my sheets suddenly view only when I try to use them on an iPad?
We have launched our Smartsheets system after months of designing and testing. We have been using iPads with the Smartsheet app during the entire process to do simple field updates. Now, the day that we launched, everyone is suddenly view only when using the Smartsheet app on the iPad, but when we log onto a computer, we…

Popular Tags

Trending in Smartsheet Basics

Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags