-
Dynamic View Logic for Required Fields
Hi there! I have a dynamic view created for Event Approvers to go in an Approve or Decline events. Depending on whether they approver or decline an event, I'd like different fields to show in the details panel as required in order to save the approval status update. However, the fields are only showing up as required after…
-
How to stop DataMesh breaking % Complete parent row roll-up calculations?
I am trying to use DataMesh to populate my % Complete column using a helper column that provides % completion based on the Status column (because my PM doesn't want their employees to have to enter percentages, but rather statuses). I have the DataMesh config set to copy what's in the helper cell into % Complete. In the…
-
Data shuttle date filter
Not able to filter dates, ie 1/1/1977 from source Excel sheet. The Excel sheet's date is a formula, would that be a reason it is not filtering dates in Data shuttle?
-
Off loading from Control Center Intake sheet with Data Shuttle
Is there any risk using Data Shuttle to off load data to excel so I can use the data to then in take to a different sheet.
-
Smartsheet Merge for Google Docs authentication error
Hi, I'm having an issue with the Google Add-On Smartsheet Merge for Google Docs authenticating. I have read the following document: Smartsheet Merge add-on for Google Docs | Smartsheet Learning Center. As well as other articles in the Smartsheet Community and Google search and help results. After I click Connect to…
-
Dynamic Dropdown List on Form
I'm working on creating a form for travel document submission. They have to submit travel documents by specific trip number. I want to make the drop down list for trip numbers dependent on the division the select. ie They select Division A, they only get a list of trip numbers for Division A. Additionally I want to limit…
-
Report Dynamics within Control Center Blueprint
Hello, I'm working on my first control center blueprint and am having two issues around reports within the blueprint. As background, I have Data Shuttle deposit all the accounting results across several project IDs in a central sheet within the control center Admin folder. Each project blueprint has an income statement…
-
Global update - cross sheet formula needed
Hi All, While doing a global update I added new column ( type: Contact) I need to change the formula to that column. The issue is the formula is cross sheet =IF({Project Metadata (Do Not Edit) Range 3} <> "", {Project Metadata (Do Not Edit) Range 3}) it is meant to pull a an email address into the column from a different…
-
Dynamic View Issue
Hi! My company uses Dynamic View to provide information to our field sales reps. When they receive a Dynamic View link, they know to use the Sign in with Microsoft button, and once they click that, they are then automatically taken directly to the Dynamic View contained in the link. However, this past Friday (8/2/24), a…
-
Has anyone figured out how to set a default size to pdf text for the Document Generator?
We are hoping to utilize the Generate Documents feature for both internal and client facing processes but cannot seem to figure out how to stop the data that maps into the forms from auto-sizing itself. This is making the client facing forms look horrible. None of the existing size formatting in my pdf carries over, and we…
