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.

Dropdowns in Reports
Hi all, Having issues with my reports where the dropdown options that I want to update (in the report) are not functional. I see that this has been a bug before and am wondering if it is happening again/if there is a work around? Thanks
% complete not rolling up
Friends, I am having a hard time with the % complete. All I want is a simple % complete - regardless of the duration. My parent / child rows are correctly intended. I have 3 tasks - Task 1 - 75% complete Task 2 - 25% complete Task 3 - 50% complete Parent % complete should be 50%. How do I achieve this? Thanks.
Exclude one item for the count
how can I exclude N/A on the count if N/A is selected Formula: =COUNTIF(CHILDREN(), "Done") + "/" + COUNT(CHILDREN()) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNT(CHILDREN()) * 100) + "%)"
Please help with formatting issue regarding C&P from external documents
Previously, I've been able to C&P multiple sections from an external document, and Smartsheet would automatically separate each section into separate rows in a selected column correctly. Now, the functionality doesn't work. What settings, or formatting, has changed? How do I get this to work correctly again? It's a HUGE…
integration de smartsheet con gmail add-on
perdon, pero solo hablo español. No domino el ingles. Voy a transcribir lo que me dice el traductor. no veo la forma de vincular los correos con renglones de una hoja del smartsheet. Sorry, but I only speak Spanish. I do not speak English. I will transcribe what the translator tells me. I do not see how to link the emails…
Row numbers to a dashboard
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last…
Hyperlink from a report
I have a report from a smart sheet. I want to have a hyperlink to be able to open the data sheet from the report, but the data sheet is not listed as a sheet when you open the hyperlink to another sheet. Why can I not see it?
USERS/COLLABORATORS
Why we have a Business plan with 100 users/collaborators and the system is asking me for more licenses when sharing a Workplace with few peoples. Our Business plan has 3 Licenses. account wj@toperbee.com
Delay in Alerts and Update Requests
My assumption is all the global problems this week with "Report Delays" as documented at https://status.smartsheet.com/ is actually not the whole story or only thing affected because automated alerts and manual update requests take several hours (8 or 9) to reach a person's email inbox. Anybody else out there with this…
Select multiples in either a drop down or check box on a form?
I am working on a customer survey (form) and would like the customer to be able select multiple items in a drop down or have multiple check boxes available in a single column? Is this possible now? Is this in development? I know there a couple of ways to work around this but nothing very elegant comes to mind. It's…

Popular Tags

Trending in Smartsheet Basics

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%
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags