Smartsheet Basics

Archives for June 2022

Can you have a URL open in a different tab when linked in a Form?
Currently if you click on the link, it takes you away from the form and you lose your progress. Can this open in a new tab? If not, any suggested work arounds for this? TYIA
I am trying to set an automation to trigger a daily email when a value in a cell is equal to 1.
I have the automation set up to trigger an email when the value changes from 0 to 1 but I also want to be sending a daily email if the value is 1 and does not change.
Dependencies
How can I make sure a task can't be completed until its defined predecessor is completed?
Email Notification omits..
Hello, I want to send email notification to coworker's email when someone check the checkbox. I made automation workflow like attached below. When I check the checkbox and save the sheet, sometimes email notification works well but sometimes email notification doesn't work. I test several times to see how it works in same…
Timeline Display dialog box: checked becomes unchecked
Hello, I have encountered following issue. When checking the box “Open to Today’s Date” in the Project Settings - Timeline Display dialog box , the Gantt chart applies this selection correctly. However, upon returning to the sheet (after a few hours), the box “Open to Today’s Date” is unchecked again. I have the same…
Form Query String - Changing Hyperlink
I need to create a form that will have a unique, clickable URL code. I can successfully autofill a section of the form to contain this hyperlink but it is not clickable since it is an editable field (see example below). Any ideas?
Is it possible to have multiple file upload fields in a form?
Can anyone edit locked columns in a sheet that's added to a Teams channel as "editable by anyone"
Hello, First of all, thanks for your assistance with my question 😊 So, I am an owner of a Teams channel. I am also the owner of a Smartsheet. If I add the sheet to the Teams channel "as editable by anyone" in a tab, will all Teams channel users be able to edit all parts of the sheet, including locked columns? Thanks!
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
Issues with creating a Bar Graph on a Dashboard - Unable to select appropriate data
Hey everyone, I've got a question regarding a Smartsheet Dashboard. I have created the outline of my dashboard, and begun to pull some of the figures into it. When trying to pull the two columns I need to create a bar chart (overall employee satisfaction by department) I am unable to actually choose the two columns I need…

Trending in Smartsheet Basics

See a form and not spreadsheet
Hi! When I send a request for approval, the customer receives it, and they open the request. How do I tell SS to open a form instead of the SS. Is this automatic?
CopyRow Automation Not Triggering
Hello Everybody, My team and I use the CopyRow Automation for project intake. Instead of using a form that feeds into a sheet, we manage two separate sheets: One for each of my team members (source sheet) One for the service team that performs the work (destination sheet) The CopyRow workflow is triggered when a field…
How to track progress of multiple people who are assigned to one task
Hi, I have set up "Assigned To" column to allow multiple contacts per cell. For example: There are 5 trainings that 4 people have to complete before moving on to the phase. I would like each of them to check off once they complete each training so the team can see the overall progress for the preparation phase. TIA.

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

Watch video

Smartsheet Basics

Discussion List