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.

Widget Interaction
Hi does anyone know of a way to link a widget to another through click interaction? I want to click on an image widget and get it to take me to a shortcut widget that contains a list of URL links. The widgets are on the same dashboard. For example, I have an image widget titled Kanban, when I click on that, I want it to…
Search text based upon date
Hi Im struggle to put together a (what should be simple) statement to search a column (section) based on the month it was checked. From the attached table i want to pull the data out of the sheet into another and record that the check has been completed for each month. So the output would be in march electrical repairs,…
Live Data Connector & Excel (no success with larger reports)
I'd like to connect to a report that is 32 columns by 217K rows, but I don't think it's going to happen. I've tried switching to a newer computer and that increased the number of rows I could pull in but it's still not even close. I even managed to test 64 bit office with the 64 bit connector but sad to say that didn't do…
Sum Children
Hi, I'm not able to get the sum children to calculate on the parent column and still showing a zero amount. Any suggestions?
Report or view for staff allocations
I'm a Smartsheet newbie. I'm trying to figure out how to pull a report (or a different kind of view) to show staff allocations across different sheets. Any help would be appreciated. Thanks!
Inactivate a Task
Is there any plan to create functionality to inactivate a task? I'm looking for a way to indicate a task is not needed AND remove it from calculations (schedule, predecessors, % complete, etc) yet still keep it visible (with a line through it) in on project plan. We are forced to make all these edits manually, when it…
Cell Linking
I am linking a cell (that should have text in the box) to another sheet. When i link it, the text disappears and a date shows up in the cell. How can i change this back to text?
RYGB formula linking to Status Drop-Down List
Hi SmartSheet Experts, I'm trying to automate RYGB status ball colors to link to the following options from a "Status" column drop-down list, as follows: Green = In Progress Yellow = Potential Delay Red = Behind Schedule Blue = Complete Here's the formula I've come up with, but it's giving me an "#Unparseable" error.…
THANK YOU!!! We can now assign multiple contacts to a column!!!!
Good morning! I just received the email update from Smartsheet Engage 2018 and I. AM. THRILLED!!! We can now choose to allow multiple contacts (up to 20!) to be assigned to a row. See the article here: https://goo.gl/sTwxNZ Blessings, Loann
Card View
When in card view, is it possible to create a new card and use different fields? Or do all cards have to have the same fields? Thanks

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