-
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…
-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66
I'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute function. Thanks in advance
