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.

Need to average with multiple criteria - Avg(Collect... not working!
Hello, I am trying to average scores in a column when criteria is met in two other columns. I know SS does not support AverageIfs, so I used AVG(Collect…. It did return a calculation, but the figure is not correct when compared to a report that has the same data or when I manually calculate the figure. Formula used…
Automated emails not sending attachtments?
I have a simple automation set up where if Cell 1 has any value in it, It will send out an email to the requestor. Sometimes we have to include attachments but it doesn't always send. I already have it set up to send the information needed and I made sure attachments were checked as well. I also told all the admins "add…
Copy Comments
Is there a way to copy comments made in one sheet to another? Meaning, any comments made in Sheet A, will automatically be copied over to sheet B. Thanks
Communication with external clients on projects
Hello Smartsheets community! Is there another way communicate external clients without giving them access to sheets used internally besides adding them to proofs?
How do I embed a timeline into a dashboard?
I am currently trying to populate a timeline from my project sheet to a dashboard, but none of the widgets enable that functionality. Does anyone have any ideas?
Why is there an indent on my dashboard report?
Hello, I have report that is created from a project plan using a helper column to bring in parent level tasks. When I add the report onto my dashboard the last entry in the report is indented, I don't understand why this is and how to fix it.
Sharing Templates
I've created a Testing template for UAT/SIT that I have used internally and would like to share with Smartsheet, does anyone know the process of doing that? Is there an approval process?
Control Center Project Archiving - Update Project Profile Data
I am building out a Archive in control center to archive projects once they are complete. As a part of the process, I want to update the Project Profile data to update a sheet showing that the project is Archived. I have added a column to the intake sheet and the Summary sheet. In the Archive workflow, I see Update Project…
Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have…
Documents attached to row and Docusign?
Hi, I searched the community and what I read make me think this is not possible, however I wanted to ask, so I knew for sure. When I attach a document to a row and click the generate a document to be sent by docusign. Is there any way to get the attached document to send with docusign? I can't find a way to map it into the…

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