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.

Using a cell to reference and sum a column on another sheet
I am trying to get the sum of an entire column where the column name (or the first cell in the column) is equal a cell on another sheet. My main sheet looks like this: And I am trying to sum each of these columns from another sheet to the first where the name matches the cell in the primary column: Is there a way to either…
Change location where Smartsheet Merge documents are saved in Google Drive
I usually only need to run one row at a time through Smartsheet Merge, and I find it unendingly annoying that Google Drive creates a new folder for each one file every time. I wish I could select the folder where I want the file to be saved. Any ideas?
Is there a way to logic-trigger different custom labels/descriptions for the same field?
Is there any way to set up logic in either Dynamic View or Forms so that the trigger displays the same field but changes its custom label? I am building a solution for a performance assessment process where the base questionnaire is the same; however, different departments need to phrase the question differently. Example:…
Automation Emails not sending
I am trying to set up an automated email to go out when certain criteria are checked. I only receive a notification, not an actual email. I've checked all the settings and whitelisted the email address, checked spam folders, etc. The emails are not coming through. Any ideas?
Elapsed Duration with 'e' Adding an Extra Day and Ignoring FS Predecessor
This discussion was created from comments split from: Elapsed duration is calculating one additional day.
Workflow Deleted but still sending email alert to users.
Hi, i have deleted my workflow, but my users still receiving the workflow alert? How this happen if workflow has been deleted? Thank you.
How to Create a Smartsheet from a Report?
This discussion was created from comments split from: Can I create a sheet from a report.
Why do reports change column name for Modified by and Modified columns?
I have multiple sheets I'm rolling up into a report. Each sheet has a "Modified by" and "Modified" column, except I've renamed them (in every sheet) to "modified_by" and "modified_date". However, when I create the report, it only let's me select "Modified by" and "Modified" as the column names. Why? Does anyone know a…
Notification help
Hi, I'm trying to use Smartsheet to send a notification per line of information from a sheet. I have used notification before but for this one I can't seem to get it to do what I need. I will have a sheet and will need to pull out 3-4 data points from columns. Some people may be on the sheet several times, but I need them…
Restoring Deleted Items: How to Recover Folders and Maintain Original Structure
This discussion was created from comments split from: Recover deleted important folder.

Popular Tags

Trending in Smartsheet Basics

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags