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

Column Type Reverts to Dropdown List
I have a sheet, that no matter how many times I change a Column Type to Check Box, it reverts back to Dropdown list. What could be the source of the issue? I can't find any automations or Data Shuttle items that would even reference this sheet. This column is a formula that is referencing a check box on another sheet, so…
HOW-DO-I: Send All Row Attachments when PDF is generated?
I'm trying to attach all row attachments to an email using automations. The problem is that the system seems to only include attachments that were generated by that process, and the files I need attached are from two different processes. Files: image.png - Uploaded to the form. It currently shows in the approval page (Not…
Using a Summary Sheet?
Hello, I currently have a sheet that has the following columns: Primary, Address, Tenant, (Other columns)… Task1, Task1 vendor, Task1 Fee, Task1 paid via, Task2, Task2 vendor, Task2 Fee, Task2 paid via, Task3, Task3 vendor, Task3 Fee, Task3 paid via,…Task7, Task7 vendor, Task7 Fee, Task7 paid via. I'd like to copy the rows…

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

Watch video

Smartsheet Basics

Discussion List