Using Smartsheet

Link to a dashboard in approval automation?Accepted Answer

Accepted Answer Kim Shaddix 14 views 3 comments 0 points Most recent by Paul Newcome 07/29/20

First post 07/23/20,Last post 07/29/20
I have a dashboard that requires approvals - the only way I know to handle this is a link in the dashboard to the underlying sheet - where they can mark their approval. Three approvals are needed - and I want to automate it so it will se…
Using Smartsheet143
Kim Shaddix
Email validation for Forms or Workflow conditions

Eric Fuller 168 views 5 comments 0 points Most recent by Genevieve P 07/29/20

First post 01/02/20,Last post 07/29/20
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
Using Smartsheet1685
Eric Fuller
Newly Created Groups not appearingAccepted Answer

Accepted Answer Anthony Noe 15 views 3 comments 0 points Most recent by Andrée Starå 07/29/20

First post 07/23/20,Last post 07/29/20
I have created a few groups and added members over the last 24 hours - however when I attempt to share sheets or dashboard - they do not appear as an option. I have submitted a ticket - but have not yet heard back from support. Am I missin…
Using Smartsheet153
Anthony Noe
Can I set the default value for a drop down list to be a formula in a form?

Samara McCallum 19 views 3 comments 0 points Most recent by Andrée Starå 07/29/20

First post 07/27/20,Last post 07/29/20
I am creating a SmartSheet whose rows are filled with the submission of the form and I wanted to utilize the hidden feature of the form to autofill a field when the form is submitted. I wanted this field to hold a formula that would select…
Using Smartsheet193
Samara McCallum
Notifications are not working

Anelise Wilhelm 167 views 6 comments 0 points Most recent by Andrée Starå 07/29/20

First post 04/15/19,Last post 07/29/20
We are not receiving any emails from our Smartsheets today.
Using Smartsheet1676
Anelise Wilhelm
Can I add one more Symbol to a column?Accepted Answer

Accepted Answer Jignesh Desai 15 views 8 comments 0 points Most recent by Paul Newcome 07/29/20

First post 07/24/20,Last post 07/29/20
Hello, I have a "Status" column with four symbols: Red, Yellow, Green, and Grey. I would like to add one more "Blue" color to it. Is it possible? Thanks in advance for your help. Regards, Jigs
Using Smartsheet158
Jignesh Desai
Auto fill form for status updatesAccepted Answer

Accepted Answer sravya.gupta127326 10 views 8 comments 0 points Most recent by Andrée Starå 07/29/20

First post 07/29/20,Last post 07/29/20
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - i…
Using Smartsheet108
sravya.gupta127326
Don't send the link of the sheet in a notification

Gilles16 276 views 14 comments 0 points Most recent by Andrée Starå 07/29/20

First post 01/16/19,Last post 07/29/20
HI all, When I send a notification to someone, I dont want to send the link of the seeht, only the notification. Is it possible ? and how Thank's
Using Smartsheet27614
Gilles16
How can I add additional fields to the View By list in Card View?Question

Answered - Pending Review Kate Erickson 10 views 1 comment 0 points Most recent by Andrée Starå 07/29/20

First post 07/28/20,Last post 07/29/20
I have a sheet that is only displaying the Status and Priority dropdown lists. I have other dropdown lists that I would like to be able to select in the View By list. How can I get them to appear in the View By List?
Using Smartsheet101
Kate Erickson
Conditional Formatting Lost in One SheetQuestion

Answered - Pending Review director62476 64 views 12 comments 1 point Most recent by Genevieve P 07/29/20

First post 07/06/20,Last post 07/29/20
Today i noticed that in one of my sheets all Conditional Formatting is lost. Anybody else experiencing this? I've already submitted the issue to support.
Using Smartsheet6412
director62476
Metric Widget - Multiple Cell Display

Bryan Sampson 337 views 6 comments 0 points Most recent by sravya.gupta127326 07/29/20

First post 05/15/18,Last post 07/29/20
I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is pres…
Using Smartsheet3376
Bryan Sampson
Any plans to add ability to craft macros in a sheet?Question

Answered - Pending Review Michael Murphy 19 views 2 comments 1 point Most recent by Garo Stone-DerHagopian 07/29/20

First post 07/13/20,Last post 07/29/20
Are there any plans down the road for Smartsheet to add the ability to write code behind the scenes (similar to vba for Access, Excel, etc.) or incorporate vba?
Using Smartsheet192
Michael Murphy
I would like a form response to trigger a new sheet, is this possible?Accepted Answer

Accepted Answer Kaitey Elliott 8 views 3 comments 0 points Most recent by Andrée Starå 07/29/20

First post 07/28/20,Last post 07/29/20
If it isn't possible, what are your best recommendations for accomplishing the same thing? Thank you in advance!
Using Smartsheet83
Kaitey Elliott
How to get indent/outdent to be used...not faded on toolbar?Accepted Answer

Accepted Answer Tamara Sprung 50 views 11 comments 0 points Most recent by Andrée Starå 07/29/20

First post 04/17/20,Last post 07/29/20
I have an acct through my work. I actually have two accts. One I don't have the ability to make changes to a document unless the author gives me permission...nor do I have the ability to create a new doc. However...I do have the ability…
Using Smartsheet5011
Tamara Sprung
How do I turn the result of a form into a PDF?Accepted Answer

Accepted Answer Michael Hair 25 views 5 comments 0 points Most recent by Andrée Starå 07/28/20

First post 07/21/20,Last post 07/28/20
Is there a way that I can get a PDF version of a form automatically emailed to me every time that form is filled out? I would like this PDF to look similar to the form that is sent when a Send Update Request is requested under the Row Acti…
Using Smartsheet255
Michael Hair
Deleted a Workspace and cannot undelete itQuestion

Answered - Pending Review Silvia Rangel 20 views 3 comments 0 points Most recent by Paul Newcome 07/28/20

First post 07/28/20,Last post 07/28/20
Hello Community, I need help!! LOL By mistake deleted a workspace on 7/23/2020, l was not the owner but had Admin rights, l can see all the items in my deleted items folder: (Image) But when l try to Undelete them l am getting this error m…
Using Smartsheet203
Silvia Rangel
Any potential to show multiple columns in Calendar View versus just the Primary Column?Accepted Answer

Accepted Answer darren hubbard 11 views 1 comment 0 points Most recent by Paul Newcome 07/28/20

First post 07/28/20,Last post 07/28/20
We wanted to create calendar views from our existing implementation projects and corporate HR functionality but the Calendar View is only showing data from the Primary Column. Is there potential future expansion to edit which columns are …
Using Smartsheet111
darren hubbard
Calculating Weeks out from a date

Crystal.Jaimes90511 223 views 14 comments 0 points Most recent by Anna Keeton 07/28/20

First post 10/01/19,Last post 07/28/20
I am trying to calculate weeks out from a set date, and figured out a way, but wondering if there is an easier way without having a helper column (Days Diff column). The below columns is what I have: Weeks Out Day Diff Start Date …
Using Smartsheet22314
Crystal.Jaimes90511
Formula QQuestion

Answered - Pending Review Kim Michael 10 views 2 comments 0 points Most recent by Kim Michael 07/28/20

First post 07/28/20,Last post 07/28/20
Currently I have a cell with a formula to determine "Days Till Due" (=[Due Date]@row - TODAY()) based off a due date cell. I also have a status cell that has the drop down with: complete, in progress, not started, roadblock. I h…
Using Smartsheet102
Kim Michael
Issue with Formula AutofillAccepted Answer

Accepted Answer Joe Miner 22 views 13 comments 0 points Most recent by Mike Wilday 07/28/20

First post 07/27/20,Last post 07/28/20
(Image) Hello, I am currently trying to make an equation driven total column. Currently I am experiencing issues with the formula not autofilling to the next row. I have looked at the help page that describes the necessary criteria for aut…
Using Smartsheet2213
Joe Miner
Today's Date in a Dashboard

Scottf06 919 views 15 comments 0 points Most recent by jmoser 07/28/20

First post 03/18/19,Last post 07/28/20
Hi, I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget? Thank, Scott
Using Smartsheet91915
Scottf06
Is there a way to add a logo to individual reports?Question

Answered - Pending Review Nicole Emard 13 views 1 comment 0 points Most recent by SoS | Dan Palenchar 07/28/20

First post 07/27/20,Last post 07/28/20
I am providing weekly job status reports to each of my customers. I would like each report to have my company logo and the customers company logo on it. Creating a dashboard is the closest I have got but there are too many columns in the …
Using Smartsheet131
Nicole Emard
Frequently Disconnected/Logged OutQuestion

Answered - Pending Review SoS | Dan Palenchar 20 views 1 comment 0 points Most recent by Sean Morgan 07/28/20

First post 07/24/20,Last post 07/28/20
Hi everyone, I've taken this up with support but in the meantime (several days and counting). About a week ago or so I noticed that as I go about my day to day work, pretty much exclusively in Smartsheet and very active use, I get spontane…
Using Smartsheet201
SoS | Dan Palenchar
Formula for determining the weekAccepted Answer

Accepted Answer Rainier Hollands 17 views 8 comments 0 points Most recent by Paul Newcome 07/28/20

First post 07/21/20,Last post 07/28/20
(File) Hi Everyone, I have a grid in which all my truck data goes in every day. For the data that goes into that grid everyday, I have created a column in which I want it to tell me what week of the month it is. I would also like my weeks…
Using Smartsheet178
Rainier Hollands
RYG balls status with multiple conditionsAccepted Answer

Accepted Answer Michelle B 19 views 3 comments 0 points Most recent by Paul Newcome 07/28/20

First post 07/27/20,Last post 07/28/20
I am currently trying to have RYG balls change colours if they comply or don't comply with criteria. If Column Serialized? is Yes, and Serial number column is empty, then RED, if it has a serial number entered, then GREEN. If Column Seri…
Using Smartsheet193
Michelle B
I need the latest or last cell value. What formula would be in smartsheet?Question

Answered - Pending Review Maryjo Reyes 15 views 8 comments 0 points Most recent by Paul Newcome 07/28/20

First post 07/24/20,Last post 07/28/20
Example: Description Wk1 Wk2 Wk3 Wk4 Structural 12 18 10 16 Mechanical 2 3 7 - Electrical 5 1 2 - Answer should be the latest or last cell value (should be number) input Structural 16 Mechanical 7 Electrical 2
Using Smartsheet158
Maryjo Reyes
Transfer changes from master sheet into child sheetsAccepted Answer

Accepted Answer Jörg Schmidt Novum Hospitality 10 views 1 comment 0 points Most recent by Andrée Starå 07/28/20

First post 07/28/20,Last post 07/28/20
Hi, I wonder if there is a way to transfer changes I make in a master (blank) sheet into the 180 child sheets I already produced and are filled with different data. Otherwise I would have to change 180 sheets again - which is... F.e. in …
Using Smartsheet101
Jörg Schmidt Novum Hospitality
Automating weekly notificationQuestion

Answered - Pending Review stuartr 74 views 3 comments 0 points Most recent by Andrée Starå 07/28/20

First post 01/29/20,Last post 07/28/20
I need some advice on creating a workflow that will meet the following requirement. We created a calendar and online booking form in smartsheets to allow people to submit requests via the form to attend an event. These requests are triage…
Using Smartsheet743
stuartr
Smartsheet chart reneame "the source data for this chart has been changed"Question

Answered - Pending Review sahilhq 27 views 3 comments 0 points Most recent by sahilhq 07/28/20

First post 07/03/20,Last post 07/28/20
Hi, Is there a way to reneame the error message Smartsheet charts show ("the source data for this chart has been changed") when there is no data in the underlying report it's being driven from? I have set up my charts in such a w…
Using Smartsheet273
sahilhq
MS Teams: cannot save filtered view?Question

Answered - Pending Review Liz Lomax 18 views 1 comment 0 points Most recent by Anna Lee 07/27/20

First post 07/23/20,Last post 07/27/20
Hi, I have a daily task review that we run via Microsoft Teams. We have our smartsheet to-do list in teams and work our way through it. What I finding really frustrating is that I have to apply a filter to hide the completed tasks every ti…
Using Smartsheet181
Liz Lomax

Using Smartsheet

Using Smartsheet

Discussion List