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.

Problem with #invalidrefs
I have built a datasheet, which pulls data from a source sheet ("PD Database"). I added over a hundred formula to the datasheet, along the lines of: =SUMIFS({PD database Range 5}, {PD Database Range 4}, "PL", {PD Database Range 3}, "No") The formula were all working fine, and data was being pulled across into the datasheet…
Rows vs Columns
I want my automated email notifications to send per project not as a group. When notification for a group of projects is sent, it is sent in column format which can not be read easily. I like the row format sent with individual updates which is what we want the program to send. How do I make multiple changes to multiple…
Counting from Sheet Summaries for Reporting
Hey there, Novice user here with likely a novice question — however, a Google search didn't lend an answer to my question. :-) I have a field that's currently in sheet summaries within a workspace, and that field is populated via a drop-down menu to select which team is working on a project. I know that I can make a Sheet…
Resource Loading without Resource Management enabled
Smartsheet resource management is not robust enough for our needs - we have multiple sheets and each sheet relies on dates in another sheet. We were having to do a lot of column duplication to bring info in and then set up conditional formatting/rules to flag when the columns didn't match. We see this as being very admin…
Proofing- Previous Versions
Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still download the older version you just can't see them on the proofing panel. This means you…
Bar- / QR Codes
Hi Guys, we have to check a certain number of technical facilities once a week. At the moment we are working with a form in wich you choose the facility you are looking at and the input the relevant data. Is it possible to choose the right form by scanning a code? How can you generate Bar- or QR Codes from Smartsheet?…
Automating reports - if blank I don't want to send.
How do I avoid automatically sending a report if it is blank whilst sending if it has content?
Printing forms
Hi, There any form created on smartsheet set a collumn to each form field. So in case a have more than 7 I probably will face some width issues during printing. is there any mask (or any other path) that I can printing the sheet form information on the same form layout?
Dashboard Search Field
Hi. I have no idea if what I am after is possible. I have a report from a couple of sheets and I would like to have this displayed on a dashboard. The hard part is I would like it displayed like a form. So you can drop down the primary column, select the name you want and the rest of the report line is shown. But only that…
Please！How to add symbols with formulas in the dashboard
How to add symbols with formulas in the dashboard Example: If more than ten days, a red flag is displayed Show green flag if less than five days If a yellow flag is displayed between five and ten days

Popular Tags

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags