-
% complete using checkboxes
Is there a formula or function that will count up the # of children checked off and report the total % checked in the parent row? As an example, I have two out of six activities (children) checked off, which means the parent work package is 33.33% complete. I would like the parent checkbox to report the 33.33% and update…
-
How do I change the columns on a task rollup report?
I'm trying to replicate the Task Rollup report that is available in the Smartsheet templates. However, for reasons I can't figure out, I'm unable to get different values for the Status column to populate the columns like the template does. Instead, it imports every task in the base file and it's respective status as rows.…
-
Populate Dropdown
Is it possible to populate a dropdown field with values from a column in a sheet using a formula? thanks! Adam
-
"Iterative" Formulas or Loops
Hello everyone. I am having an issue where I do not see a way to make any of my formulas iterate any specified number of times, let's say similarly to a "for" loop in a programming language. I am curious if there is a solution I am overlooking or if this is not currently doable with Smartsheet. Please see my example below,…
-
Can a Smartsheet form populate a PDF, and then send that PDF to Slack
Hi My company has a logistics driver that delivers sets to theatre. He usually fills in a paper form of what he has dropped off and then takes a picture of that and posts it on Slack. We have decided to move over to a paperless system and have made a smartsheet form to track which sets are delivered. Each time a new row is…
-
Combine Multiple Form Fields into one column
We are using a form to enter new customer information into a smartsheet file. Our key is a formula setup with multiple columns combined to create the unique key, since some of our customers work for the same company out of the same office location and we need to be able to search by all. Is there anyway to combine in the…
-
Want to know how enabling Smartsheet WDC to Safe List in Tableau Server Impact its performance.
Want to know how enabling Smartsheet WDC to Safe List in Tableau Server Impact its performance. Want to know how it works (pull data from smartsheet to tableau server ), about its API and how much resource of tableau server it needs to work.
-
Can Smartsheet lock a column AFTER data is input, for referencing in Update Requests?
Hi, I have a Smartsheet workflow I would like to implement and can't seem to figure out if it's possible. I have a sheet with four columns: Name, Date (formula set to the following Monday after the CreatedBy date), Commitment Detail (a work task they are promising to get done), and a Commitment Completed (yes/no dropdown)…
-
Kanban style dashboard
Hello, I would like to build a kanban style dashboard from a project plan or any other sheet that contains an action/owner/status. The second step, is I can create this Dashboard to bring together actions from multiple sheets. e.g. I can have action list 01 and action list 02. Bringing them together could show me the…
-
Who could use a PARSE function?
So I have been trying to think of how to best word it, and trying to help someone else with a solution led me down the rabbit hole I needed. How about a PARSE function. =PARSE(range, selection number, delimiter) Use case would be plentiful, but a couple of examples would be... A. You want to search a range for the second…
