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.

Report criteria based on two sheets, matched on row
Is it possible to create a report based on data from two sheets, but criteria is include only rows where the entry in primary column in one sheet is identical to the entry in its counterpart column in the other sheet? In other words, matched on rows? I don't see where to set this in the report builder.
How To Build Report Based On Created Date
Hi everyone, I really need help of your expertise. I have develop one form and its purpose is to collect Facility Manager (FM) daily inspection on each floor. I have created one column "Created_Date" just to monitor new submission from FM. As you can see in "1.JPG" Each Question has yes, no and N/A answer. In "2.JPG" is…
Duplication of form creation
Duplication of form creation should be highlighted to the user while creating a new forms based on the parameters is this possible.?
Sheets
Dear, I now have 10 sheets, can expand to 30 sheets.
Smartsheets Sending Mobile App Notification, but Not Email
I have a conditional alert set up in my form to send an email every time a row is added. When I use a form to add a row, it sends me a notification on my phone through the app, but it isn't sending me an email. I checked my spam filters and there is nothing in there being held. Has anyone else had this issue? This form is…
converting data sheet to format below
Hi, I am trying to convert a data sheet into a widget like the one below. Does anyone know how I can do this? Thank you! Lindel
Auto notification. When attachment downloaded
Hi. - I run a sheet with form to collate drawing data. the original form user uploads a drawing and this populates the sheet. the auto alert tells the other client (via email) of an attachment available for download. The client then downloads the attachment. Is there an auto alert to advise me - admin -that the attachment…
Sum of Multiple Date Ranges
Hello, I am trying to find the sum of Net Work Days between three date ranges. Expected Dock Date & Dock Date Available for QC & QC Complete Date Received into Sage & Expected Receipt This formula isn't quite working. It may be that not every one of these dates has been populated yet, but ideally it would be a + or -…
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
Enhancement Request: Return counts lost in UX Changes
There was this: https://community.smartsheet.com/discussion/ux-changes-release-2018-02-13 I continue to miss the counts that were so visible and usable. Filter count - I now have to unfilter/filter to see a dropdown -- which goes away after a few seconds. Discussions. Open Update Requests. Attachments. I now have to click…

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