Using Smartsheet

Hide email addresses when sharing pageUnanswered Question

Question Ryan Nix 2 views 0 comments 0 points Started by Ryan Nix 03/28/20

First post 03/28/20,Last post 03/28/20
Hello, we have a dashboard that we want share among different groups but in our testing, we saw that the email notification notes the various emails that are included. Is there a way to hide these email aliases? Since these are different g…
Using Smartsheet20
Ryan Nix
How can I publish my Donation Calculator sheet for all my clients to use?Unanswered Question

Question Kevin Minkoff 4 views 0 comments 0 points Started by Kevin Minkoff 03/28/20

First post 03/28/20,Last post 03/28/20
https://us.v-cdn.net/6031209/uploads/486/QGUU7M9NWCFD.png Forms only allow data entry in a single column. That won't work. If I publish my Donation Calculator sheet, it retains the previous entries. Is there a way to force the sheet to cle…
Using Smartsheet40
Kevin Minkoff
How to create a Line Chart to automatically include data from new rows entered in a sheet.Answered Question

Answered Mohammed Sulaiman 14 views 2 comments 0 points Most recent by Mohammed Sulaiman 03/28/20

First post 03/25/20,Last post 03/28/20
I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet. How this was set up: In the original data sheet, the actual and expected performance of a parent level task…
Using Smartsheet142
Mohammed Sulaiman
Limit to Dropdown values?Answered Question

Answered jmpbell 11 views 8 comments 0 points Most recent by Andrée Starå 03/27/20

First post 03/27/20,Last post 03/27/20
We're creating a sheet where we want to have a column of a dropdown single select type. What is the limit to the number of values? For example, we have hundreds of departments we want to choose from, but have the submitter choose one from …
Using Smartsheet118
jmpbell
Cross-Sheet Duplicate CheckboxAnswered Question

Answered Christina Riot 7 views 2 comments 0 points Most recent by Christina Riot 03/27/20

First post 03/27/20,Last post 03/27/20
I have found a few things via smartsheet community on this but I just cannot get this formula to work. I am working fast and furious, so maybe I'm missing something obvious. I am trying to look up a badge number from one sheet and match …
Using Smartsheet72
Christina Riot
Choosing the right criteria for row reports?Unanswered Question

Question Mark Silvester 6 views 0 comments 0 points Started by Mark Silvester 03/27/20

First post 03/27/20,Last post 03/27/20
I am trying to create a report that pulls specific rows from multiple sheets (that are similar in structure) into a high level overview that shows: Opportunity Name SKU Adjusted Count Shipped Remaining Target Arrival Date I've pasted an …
Using Smartsheet60
Mark Silvester
FormsAnswered Question

Answered Kevin Minkoff 11 views 2 comments 0 points Most recent by Kevin Minkoff 03/27/20

First post 03/27/20,Last post 03/27/20
Hello, Is there a way to create a form where fields are displayed in multiple columns? If not, is there a way to publish a sheet where all data inputs are cleared upon exit? Thanks much!
Using Smartsheet112
Kevin Minkoff
Digital signaturesAnswered Question

Answered Mike Sagel 11 views 1 comment 1 point Most recent by Alejandra 03/27/20

First post 03/26/20,Last post 03/27/20
We have internal digital signatures through our Microsoft CA server. Is it possible to have a field in smartsheet that would accept and store a signature?
Using Smartsheet111
Mike Sagel
Group update request by recipient (even if there are multiple owners)Answered Question

Answered k.lakshminarasimham38821 11 views 2 comments 0 points Most recent by k.lakshminarasimham38821 03/27/20

First post 03/27/20,Last post 03/27/20
I have an automated workflow that runs on an action item log daily. There are multiple owners across tasks, do we have an option of sending it out as one? That way the owners won't have to go into individual forms?
Using Smartsheet112
k.lakshminarasimham38821
Scrolling a dashboard inside an iFrame on iPhone - not workingAnswered Question

Answered Dan Snodgrass 28 views 2 comments 0 points Most recent by Dan Snodgrass 03/27/20

First post 03/24/20,Last post 03/27/20
Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
Using Smartsheet282
Dan Snodgrass
Automatic Duration calculation from 2 Predecessory

Tibor Staub 16 views 7 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/27/20,Last post 03/27/20
Hello I have a Task B that cannot start before Task A was finished and that should finish the same time as Task C. When I enter 2 predecessors for B, namely that Task A has FS and Task C has FF, the smartsheet always takes into account o…
Using Smartsheet167
Tibor Staub
managing supply chain riskUnanswered Question

Question bzgryzek 11 views 0 comments 0 points Started by bzgryzek 03/27/20

First post 03/27/20,Last post 03/27/20
Do you have a template that could be used to manage supply chain risk? What template could be used in order to properly manage it?
Using Smartsheet110
bzgryzek
Protecting Folders From Admins In WorkspaceAnswered Question

Answered Jonathan Forrester 9 views 2 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/27/20,Last post 03/27/20
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …
Using Smartsheet92
Jonathan Forrester
Formula to clear in certain fields of a rowAccepted Answer

Accepted Answer Marla Berge 13 views 5 comments 0 points Most recent by Marla Berge 03/27/20

First post 03/26/20,Last post 03/27/20
I have a smartsheet for a workflow. If at some point there is a change order, then the workflow needs to start back at the beginning and most of the populated cells need to be cleared out. Is there a formula to make this automatically ha…
Using Smartsheet135
Marla Berge
Can update requests not be combined by recipient?Accepted Answer

Accepted Answer Dustin Shuman 7 views 1 comment 0 points Most recent by Andrée Starå 03/27/20

First post 03/27/20,Last post 03/27/20
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…
Using Smartsheet71
Dustin Shuman
How to give access to user specific data without allowing people to have access to the full data?Answered Question

Answered Jacques Frein 6 views 13 comments 0 points Most recent by Jacques Frein 03/27/20

First post 03/27/20,Last post 03/27/20
Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…
Using Smartsheet613
Jacques Frein
Accounting Practice workflow

Bal - CPA 59 views 3 comments 0 points Most recent by David Cramp 03/27/20

First post 08/18/18,Last post 03/27/20
Has anyone created worksheets to keep track of Client tasks for an accounting Practice? Trying to keep up with all of the assignments and tasks in one central place
Using Smartsheet593
Bal - CPA
Multiple contact column to display one contact per line w/in the cellAccepted Answer

Accepted Answer Marla Berge 11 views 3 comments 0 points Most recent by Andrée Starå 03/27/20

First post 03/26/20,Last post 03/27/20
I have a column that is a multiple contact column and when I add multiple contacts, it adds that all on the same row, how do I get the names to be displayed 1 name per line withing the cell?
Using Smartsheet113
Marla Berge
How to add logo in smartsheet Forms?

Sepi Deh 453 views 8 comments 0 points Most recent by Andrée Starå 03/27/20

First post 07/18/18,Last post 03/27/20
Hi, We would like to customize our smartsheet form in order to create an online opprtunity for Forum registration. For this purpose, we need to add the logos of our company and that of our partner. Would you please inform us how this ca…
Using Smartsheet4538
Sepi Deh
How to protect rows in a sheet from deletion but allowing update for non-licensed users?Answered Question

Answered Jacques Frein 7 views 1 comment 0 points Most recent by Jacques Frein 03/27/20

First post 03/27/20,Last post 03/27/20
Hello all, I have created a data sheet with KPI's for our team members (non-licensed users). I have created a dashboard so they could see their personal KPI's but I don't want them to have access to the full table, for confidentiality reas…
Using Smartsheet71
Jacques Frein
Deleting a UserAnswered Question

Answered Ken 17 views 6 comments 0 points Most recent by Ken 03/26/20

First post 03/25/20,Last post 03/26/20
Why is it when I delete a user that they are still included in Workflows? Wouldn't it make sense that if a user is deleted, that they be deleted from everywhere in Smartsheet? Why must I manually remove that person from every workflow in e…
Using Smartsheet176
Ken
Approval Workflow: Rejection "Alert Someone" not workingAnswered Question

Answered Geoff Baker 23 views 5 comments 0 points Most recent by Geoff Baker 03/26/20

First post 03/21/20,Last post 03/26/20
Hello, I am running a 3 stage approval process. If stages 2 or 3 REJECT the approval I have it setup to "Alert" the Stage 1 approver. https://us.v-cdn.net/6031209/uploads/336/JFIGJVM0XUBR.png I have triggered the workflow now 3 …
Using Smartsheet235
Geoff Baker
Populating a Multi-Select Column from Excel

TeriOWY 9 views 0 comments 0 points Started by TeriOWY 03/26/20

First post 03/26/20,Last post 03/26/20
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…
Using Smartsheet90
TeriOWY
Masterplan

Taru 35 views 9 comments 0 points Most recent by Adam Olbur 03/26/20

First post 04/06/18,Last post 03/26/20
Dear All, Our program consists of 5 sub projects and each of them have their plan. All of these individual plans need to be rolled up into a consolidated master plan that would finally track the inter-dependencies and the critical path. …
Using Smartsheet359
Taru
Cost Code Verification-Budget vs. ActualsAccepted Answer

Accepted Answer Clint Stitser 9 views 3 comments 0 points Most recent by Andrée Starå 03/26/20

First post 03/25/20,Last post 03/26/20
Hello Everyone, I build budgets in Smartsheets and then import actuals from our accounting department, provided on an excel sheet, which I then manually manipulate and upload to a different sheet in Smartsheets. Then I have a few differen…
Using Smartsheet93
Clint Stitser
Can a sheet summary always reference the same cell when form entries are added?Answered Question

Answered Jessica Schemrich 14 views 4 comments 0 points Most recent by Paul Newcome 03/26/20

First post 03/26/20,Last post 03/26/20
I am trying to create a sheet summary that pull information from a form entry. The form entries will always appear in the first row. However, even when referencing the absolute cell, when a new form entry is populated, the sheet summary …
Using Smartsheet144
Jessica Schemrich
Filter table based on list?Answered Question

Answered Daniel Cardenas 19 views 6 comments 0 points Most recent by Paul Newcome 03/26/20

First post 03/25/20,Last post 03/26/20
In Excel, you can filter a table based on criteria defined in a range. (Data> Sort&Filter> Advanced Filter) In the screenshot below, the criteria range at the bottom would be used to limit rows displayed in the table above. Is it…
Using Smartsheet196
Daniel Cardenas
Is it possible to have live links on a read-only page?Answered Question

Answered JMW_PNW 14 views 3 comments 0 points Most recent by Debbie Sawyer 03/26/20

First post 03/25/20,Last post 03/26/20
I created a Report in which several other sheets report data into. It also creates a link to the sheet where each line item came from. Which is very useful. Because I need to make this report available to over 250 people I created a &q…
Using Smartsheet143
JMW_PNW
Formula with multiple conditionsAccepted Answer

Accepted Answer Silvia Rangel 13 views 7 comments 0 points Most recent by Andrée Starå 03/26/20

First post 03/26/20,Last post 03/26/20
Hello Community; I am trying to write a formula to check mark a field when 2 conditions are met; so far l have been able to make it work with 1 condition (see highlighted screenshot), but can't figure out how to add the 2nd condition to th…
Using Smartsheet137
Silvia Rangel
Workflow sending notification through Smartsheet but not email.Accepted Answer

Accepted Answer John Morgenthaler 43 views 13 comments 0 points Most recent by John Morgenthaler 03/26/20

First post 02/26/20,Last post 03/26/20
I thought based on my personal settings I can get an email notification from workflows but I do not receive one. It only comes through Smartsheet at the top right where the bell is listed. How can I get this through email? https://us.v-cdn…
Using Smartsheet4313
John Morgenthaler

Using Smartsheet

Using Smartsheet

Discussion List