Product questions?
Sign in and ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Reference worksheet name in alert automation
Please see the attached for reference. I have an alert automation to let my reception to expect bid submission on a triggered date. When I look at the email, attached, there is absolutely no indication as to what worksheet the automation came from. How do I fix this so that my admin will know the name of the project…
Form submission
Once someone fills out the form, they receive this email after submission. The spots where it says {{Tradeshow Name}} and date didn’t function properly.
How do I edit the date?
My sheets are only showing the date of June 2023 and its not letting me change it?
Trouble Copying and Pasting
I used to be able to copy and past into a sheet from an excel file. Now I'm unable to. I've tried using CTRL + V and it doesn't work. I've also tried right clicking to paste and the paste option is greyed out. ( see image)
Workflow Trigger - Any Value
I'm moving rows to a new sheet based on a column showing "Any Value". Why are rows with no value in this column (blank) still moving over when I run a manual test? Column is set as text/number. The row should only move if information is placed in this column field.
Formula to split text into columns
I want to scan a barcode into a column in smartsheet forms with the following information: barcode text: Name, Typ des Gerätes# QNummer$nicht zutreffend%Benutzer As you can see there are different delimiter e.g: , # $ % I want to split the barcode text into columns (the delimiters seperate/demonstrate the deifferent…
another question
Thank you for past help. I know when a form is submitted the submitter has option to receive a copy. Is there a way for me- my company to receive that copy as well. How can this be set?
Automation based on Sheet Summary
Can I set up an automation based on a field in a sheet summary? What I'm ultimately trying to do is set up a review/approval workflow for an entire spreadsheet. Everything I've tried so far (adding status column to the sheet, using a separate summary sheet to track approvals, etc) has been fairly clunky for our team so I'm…
How to put contact list names into a visual graphic from a multiple contact column
Hello! I have a tracker for my project team that shows all active projects and their details. One of the columns is called "Project Team" where the PM is asked to list out all individuals who are on their project team. The column lets them add as many team members as they need to. I have been asked by my Director to turn…
Issue log linked to requirements on a different sheet
Hi, I have searched and searched but can't find an answer, but I can't believe this hasn't been asked before so must be doing something wrong. I am running a post development support project where we have multiple regular releases. We gather requirements from the client develop them test them, resolve issues and release.…

Trending in Smartsheet Basics

Form Submissions aren't appearing on the sheet!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
Why is my report suddenly blank?
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
Date Formula Help
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)

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

Watch video

Smartsheet Basics

Categories

Popular Tags

Smartsheet Basics

Discussion List

Categories

Popular Tags