-
# 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…
-
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…
-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
-
Assigning multiple people to one task (I see this has been asked before)
I read through some of the threads on this subject. It really is frustrating to not have this feature. One of the primary reasons we started using smartsheets was to have a living work schedule for our employees at my constuction company. I would like to create reports that show where an employee is assigned on a given day…
-
API for newbies
Hi all, I am totally green in terms of creating API and programming stuff, but keen very much to learn it. Do you know any places to recommend as a good start points? Marcin.