-
How to remove hidden fields in tableau sheet while exporting as cross tab from tableau server?
Hi all, I am using Tableau Desktop & Server 9.3. I have created a field named as 'Sales'. There are many other measures and dimensions have been included in sheet along with field 'Sales'. But for some reasons I've to hide 'Sales' field. I've done this by unchecking the option 'Show Header'. I have published my workbook on…
-
JIRA connector set up problem
Hello, we just hooked up the JIRA connector yesterday and I have attained about 90% success with pulling Jira tickets, by epic, into a Smartsheets project plan. I'm having two issues that are frustrating me: 1. Smartsheets is not picking up the epic name from JIRA: field in Smartsheets just says: "Field 'Epic Name' not…
-
Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
-
How do I Subtract a series of days from date column?
I need to calculate a series of dates for a newsletter production cycle. I want to take the Expected Release Date ie: 25 Aug 2019 and in seven column cells, beginning with ten days from the Expected Release date, then show 8, 7, 5, 4, 3, 2 days calculated dates from the Expected Release date. I can perform this easily in…
-
Smartsheet file shorcuts
Hi there, Does anyone know how to pin shortcuts for specific Smartsheet files to Google Chrome? Essentially, I'm after the quickest way (minimum number of clicks) to open specific Smartsheet files. Thanks, Paul
-
SFDC Connector - Snapshot Then Track
I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the…
-
Family Counting
Im looking for a formula that will allow me to index down through a number of children and count the number of decendents under that child. Any help?
-
Primary column not returning values in Report
I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interestingly, when I print the report to pdf, I see the project name values.
-
Editing Conditional Formatting Rules
Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to…
-
How do I get around approvers being on vacation in a workflow?
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
