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.

Formating for dates past
I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? any help welcome. thanks G
Setting up a Notification to send to myself
Hi, I have an issue with Smartsheet and I'm not sure if I'm doing something wrong. I'm setting up a notification through the Alerts and Actions. I want to Smartsheet to send me a notification when one of my users updates a Row to tell me that an Order is being despatched. In the Delivery Settings, I have Shared user or…
Can calendar view default to current month when a sheet is opened?
It seems there'd be a way to do this but I haven't figured it out if there is. I have a calendar that displays important dates from linked cells in another sheet. I set it to default to the calendar view but every time it opens it displays June 2017 even though it's currently April 2018! I'm guessing it's drawing from the…
Notifications not working for 1 user
Hi there, I have an automatic notification set up to email the contact listed in a column once a day when the RAG status changes to red. This seems to be working so far for other contacts except for one individual. Any ideas what might be wrong? I made sure that the sheet was shared to the person, and that their contact…
Change in Status column effects Assigned to Column
I have a series of approvals that are being managed through smartsheets. There are many more status conditions and only a few people on the team. I would like to have my Status drop down options correlate to the Assigned To column. Is this possible? I feel like it could be done, but I haven't been able to figure it out.
Exactly Duplicating an existing SHEET to a new sheet
I have a sheet which records my orders as in attached. I want to make the NEW sheet with the exact same headings so I can remove the completed order from the Sheet #1 and move it to sheet #2 ( new) . Michael Ahmed michael@libertycards.com 817 937 5046 cell
IF formulas
Hi, Tried looking for my question hoping it was already answered, loving how Smartsheet community works. I'm new to Smartsheet and need help with an IF formula. My company has several titles (positions). In the Title column there is a drop down menu for 5 Titles. In another column, I have their Rounded Hours for per line.…
Delete task dependency
I'm trying to delete one task dependency on a Gantt chart. I found this quick YouTube video, which says to click the dependency line, but I'm unable to click on it. My dependency lines are not green like in the YouTube video. Thoughts?
Could we get a setting to lock the gantt chart to 5 years
It would great if there was a setting that would limit the gantt chart view to 5 years in support of shorter projects. Another option that would be even better is to have a start and end date setting for the timeline. It would make it better for printing and sharing.
Reports that pull only parent rows
Is there is a way to do this without having to create another column and naming it Parent?

Popular Tags

Trending in Smartsheet Basics

Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags