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.

Multiply 2 Columns and display the result
Hello I have an "Ordered" column and "Sell" column. I want to multiply the value in Ordered by Sell to generate an Ext Sell value in a third column. I have tried the following formula in the Ext Sell column but I get #invalid operation =SUM(Ordered:Ordered * Sell:Sell) Where have I gone wrong? Thank you
Admin Report - Sheet Tracker
Is there a report or query that can be done from the Admin account that shows all the sheets created in our cloud instance. I see that there is a total like 363 out of 500 sheets used, but it doesn't show date, who, sheet name and current status of that sheet (archived, deleted, new, etc). Is this possible?
URGENT help on Master plan roll views
Dear All, A bit of a funny help but can anyone share the view of how their master plan gnatt chart. In my consolidated plan i inserted a column with a checkbox to see which rows should be presented in the gnatt chart. However my program manager wants to see the inter-dependency link too. and I was wondering if I am doing…
Tool bar Fix Needed
Seeing large numbers of users and multiple threads frustrated over the movement of the toolbar from the side to top and loss of "tabs" vs individual windows in browser with last update. How soon will there be a sheet properties adjustment allowing individuals to choose a "view" that allows us to move back to what worked…
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

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