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

Displaying Multiple Project Phases in One Gantt Chart Line
Hi Smartsheet Community, I have a question regarding Gantt charts in Smartsheet. Currently, my Gantt chart displays a single bar for each project, representing the overall project start and end dates. However, I’d like to break down the project into more granular intervals and visually distinguish the different phases of…
Save as Folder option does not change form path and history table path. Need to change manually
Dear Team, Save as new Folder option does not change form path and history table (copying records from workflow) path to new folder location (folder created using save as option), We need to change manually. (Kindly refer below scenario) Example: I have created workflow to copy current record to new sheet whenever change…
Can I add an image uploaded to a row via a form to a PDF in Generate Documents?
I have created a mobile "model release" for photography. I present the release language and record the subjects information using a form. They can capture and upload a reference photo. I'd like that photo to be placed no the resulting PDF. Can I map file uploads to the PDF? Also, how can I get the name of the resulting PDF…

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

Watch video

Smartsheet Basics

Discussion List