-
Planview Integration
Hi, Has anyone tried or successfully pulled data from Smartsheet to Planview or any other PPM systems? If so I would be very interested to hear what the requirements were and how it was achieved. Many Thanks Paul
-
how to get a weighted average for a parent row, when children rows have "<" signs added to it
Hi there, I am currently working on a formula where the parent row will display the weighted average of children cells, based on the input weights. However, the problem I have at the moment is that there are numbers of cells with "<" sign added in front of the number and because of that, those data get ignored in the…
-
Invoke a template from a new record
Use case: I would like for a user to complete one form, and based on a value they select in the form, it logs that entry into a sheet, and also creates another sheet (a template) with a name taken from a cell in the form.
-
Printing info
Is there a way to print a list of all the people that I have shared a sheet with?
-
O365 Integration for unlicensed users
We have a Business plan with 15 licensed users, then will invite perhaps another 100 collaborators (unlicensed users) as part of the various projects across enterprise. All same organization. We are an O365 shop and have integrated all licensed users with O365. However, there does not appear to be anything but a static…
-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
SmartSheet Engage 2017 Customer Conference
Before deciding to send team members to the Engage 2017, we are trying to get a sense of others that are going? Also, if you are planning to go, are you a member of the business team or IT?
