-
ODBC Smart Sheet Connector für Excel 64Bit ist extrem langsam ?
Ich lese Daten aus 25 Smartsheets ins Excel ein. Die Daten werden in 5 Listen zusammengefasst. Imm Anschluss mit Power Pivot in einem Datenmodell verarbeitet. Es geht um eine Anzahl von in Summe 30.000 Datensätzen. Der Aktualisierungsvorgang, bis Excel die Daten Erhält dauert eine Stunde. Kann man den ODBC Konnector…
-
Updating template -> updates sheets made from the template
I would love to have the ability to make a change to a template that I created and be given the opportunity to select sheets that were created from that specific template to automatically update as well. For context: I keep track of ~130 employees training records. Each employee has their own separate sheet with all of the…
-
Extraer la Hora de 2 o mas celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas? o como podria registrar la Hora en una celda?
-
Automation: Ability to add a condition to workflow branching off from an unmet condition
Today in automation workflows you can only and conditions to flows that pass previous conditions. It would be helpful to be able to add conditions to the flows that stem from failing previous conditions. Scenario: I want automation to change the status of a task based on it's Target (completion) Date and it's Actual…
-
Status to red once the deadline is reached.
Hi everyone, I’m trying to automatically change the Status to red once the deadline is reached. I placed the following formula directly in the Status column: =IF([Ende]@row <= TODAY(), "Red", [Status]@row ) However, I keep getting the error #CIRCULAR REFERENCE. My understanding is that this happens because the formula is…
-
Is there a way to include the Sheet Name as a variable in a message?
Based on this KB article (Dynamically Add Cell Data in the Subject and Body of Request Messages) I know that we can include the names of columns (like {{Name}}), but I want to update the subject to include the name of the sheet itself (like {{Sheet_Name}}. Context: We have created a contact list template, that has a form…
-
Dynamic View does not allow anyone to change and save specific column
I have a column with a dropdown list. The column is restricted to listed values, and you can select more than one. There is no logic assigned to that column in the dynamic view, and is not listed as required. I've tried disabling the conditional logic on the sheet, and it did not correct the issue. This is happening to…
-
Is there a way to do an export of the automation workflows?
We have over 20 automation workflows setup on a worksheet. Is there a way to do an extract of these workflows to review rather than going one by one?
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Auto-Revoke/Cancel Update Request
I have an [Assigned to] contacts column with multiple contacts per cell allowed. Based on certain criteria I have a workflow setup to send an "Update Request" to all of the contacts in [Assigned to]. However, I only require 1 (one) of the contacts to provide the requested update (as they chose based on their availability).…