-
card view in Sights
please add the ability to add card view to Sights. It seems like this would have to be added to reports since that is what is used in Sights. However, however it can be done, this feature needs to be part of Sights!
-
Transfer automatic data from SmartSheet to ERP
Hi, We would like to test SmartSheet for as a order follow up system. Whenever we are entering new orders, we need to transfer the informations to our own ERP system automatic via an API solution. Is that possible with SmartSheet?
-
# of Attachments in a Cell
I would love to log the amount of attachments a line has in a cell. IE 3 attachments, I would like to have one of the cells read "3" so we can at a glance see how much documentation is added to the line. Does anyone know if this is possible with Smartsheet?
-
Restricting dropdown lists using VLOOKUP
Depending on values in one column I want to restrict the dropdown list in another column Example: I have a sheet: Employees Role Name ------ ------------- PM Jane PM John Dev Mark Dev Stephanie In another sheet where Tasks I have these same two columns Role and Name Once I enter the Role (say PM) it should automatically…
-
Excel Live Data Connector - Partial Results Returned
Hi, On Smartsheet the report returns all rows. When I export to excel it returns all rows. When I run the connector in Excel, it excludes some rows. It appears that the rows being excluded have a Text/Number value in column X i.e. D21, whereas the ones being returned just contain a number in column X i.e. 1901 - so I…
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
-
Smartsheet Python SDK Pyinstaller
Has anyone had success packaging their python applications for smartsheet into executables with pyinstaller? I've tried adding hidden imports, updating spec file, and running a clean venv with python 3.4 yet I still get an error message the second the program gets to the object associated with smartsheet. It states that it…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
-
Formulas with IF statements
I am working on if I have three sections and I only need to average one section because the other two are null, how can I write this out? =IFERROR(AVG([% Complete]73, [% Complete]76, [% Complete]79, [% Complete]82, [% Complete]85, [% Complete]89, [% Complete]91, [% Complete]92, [% Complete]93, [% Complete]94, [%…
-
Multi-Row Approvals
I want to migrate an existing SharePoint InfoPath form to SmartSheet. The form is a Budget Request Form. * Staff can submit a budget request with arbitrary number of items (rows) * Via a workflow, each item is Approved or Denied. * Via a workflow, the entire Request is Approved, Partially Approved, or Denied. The thing…