-
Formula to add multiple names to one cell
I need to create a lookup to select multiple names from 1 sheet and add those names to 1 cell in another sheet: Sheet 1: (names in multiple cells) Name - Type Rick - A Jane - B Bob - A Sheet 2: (put qualified names in 1 cell) Lookup names = 'Type A' and copy them into 1 cell. I know VLOOKUP or an INDES + MATCH can find a…
-
Show Critical Tasks In Resource View
This question is about the schedule view in the Resource addon; I'm using it to show resources assigned to tasks on different projects.(https://rm.smartsheet.com/plan) I'm using this to show the resources assigned across different Projects and want to show which tasks are on the critical path of any of the projects.…
-
SSO and CNAME
We have an Enterprise license and have set up SAML2 SSO with a CNAME per the instructions at: https://help.smartsheet.com/articles/2476141-configure-saml-sso My users are able to go to my CNAME address (e.g. smartsheet.abc.com) and automatically log in which is what we want. However, when a user shares a link to another…
-
How to use Jira-Smartsheet Connector filter so that filtered items are not in sheet?
Is there a way to use the Jira-Smartsheet Connector so that items that do not match the filter criteria are not brought into the Smartsheet sheet? I'd like to do this so that when my source data exceeds the SmartSheet sheet limits it does not break the sheet and downstream workflows associated with the sheet.
-
KNEAT
Hello, I would like connect SMarsheet to Kneat...
-
Is DataTable lookup supposed to be case sensitive?
Can't get fields to map to lookup because of case sensitivity it seems. Is this intended for DataTable? If so, there should at least be an option to look for case sensitivity or not.
-
How to transfer information to power bi on a hierarchical level?
Hi, I connected to smartsheet from powerbi, I am trying to get information about a level in the hierarchy of each line i.e., is this a parent / child line Is there a way to pass information to powerbi on a hierarchy level? Thanks, Rachel
-
ODBC Connection with Visio
Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…
-
Expanding Text Fields In Document Mapping?
Is there a way to expand the text fields in Document Mapping? The users who will fill this out will be putting in a lot of text, and the fields don't seem to expand, which causes text to overlap.
-
Multiple approvals process
I'm creating tracking for a change process through various departments. What I need after project submission into Smartsheet is: Team 1 - intake, review, notes and approval (either approved - no comments, approved with comments, or hold - with comments) Teams 2-15 - same as above No one team's approval is subject to any…
