-
How to populate a column in a sheet based on a column from another?
Beginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each of the accounts these people have. I'd like each individual name to only be included…
-
How to publish tableau dashboard connected to smartsheet to a tableau servert
Hi, I am able to connect my smarsheet data to tableau desktop app via API token. However, when I publish my workbook on my server, it prompts me to sign in with a user name and password. I am an SSO user on smartsheet therefore don't have a password. Can anyone please advise how do I get around this please? Maz
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Smartsheet Teams Integration
Hello, Is there a way to set up a Smartsheet workflow to directly message the target person on Microsoft Teams? Thank you, Luke
-
Rows Reordered
Our sheet is used as a chronological order of events. Often when others are working in the same sheet, everything gets set out of order. I know Smartsheets does not support autosorting outside of reports. However, it would help if I understood how this jumble begins! When the sheet is set out of order there is no…
-
Trigger Issue
For one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number of approvers is just one. I have a Change Status rule like this: When rows are added…
-
Admins cannot Edit our Smartsheet after sharing permissions changed
We are on a Pro Plan account with one license. We would like two people to have the ability to edit and add data to a Smart Sheet. We have granted them editing permissions and then tried giving them Admin permissions. They are both unable to edit or input any data in the smart sheet. The two people we wish to give System…
-
I need to string together many conditions
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration. =IF(AND([Contract…
-
Auto-populating sub-tasks from Form.
Hello. I have a list of tasks, assigned to different people, that have to happen each time a new topic comes up. Ideally, when a user submits those topics via a Form, I would like that list of tasks/assignees to auto-populate as sub-tasks below row of information that was submitted from the form. Is that a thing that can…
-
Is anyone else experiencing "An unexpected error?"
I am getting an error for most of my reports reading, "An unexpected error has occurred running your report and the Smartsheet.com team has been notified." Is anyone else seeing this?