-
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…
-
Data Shuttle
I am trying to build our project using the PMO template. We receive a monthly data report that lists all projects and based on a select criterion, those that meet will be accepted as new projects. I want to automatically add those projects to the intake form to create the master template. I've added the data report as a…
-
Bridge: Data Reference Doesn't Return Same as Hardcoded Value
I'm connected to an external API that requires a token to be added as a Request Header for calls. The token cannot be hardcoded to the call since it expires every hour. So I must make a call to refresh the token then use that in subsequent call's Header. When I pass the token as a data reference to the Header of the…
-
Data Shuttle adding rows not triggering automation
I have an automation set up that when a row a added and [*department* Completion Status] is empty them change [*Department* Completion Status] to "WIP" Does Data Shuttle trigger automations to run? if not is there a way to work around this?
-
Advanced notice Community post - Upcoming Microsoft Teams Reauthentication Required
Hi Community, We will be migrating our Smartsheet integration with Microsoft Teams on October 16, 2024. Why are we migrating: We’re always working to get more features to our users, this migration makes the connection between Smartsheet and Microsoft Teams more stable so we can build new features for you in the future.…
-
How to fetch hours logged data from Toggl to display in Project Dashboard of Smartsheet
For project 'A', project plan, status report and dashboard are in Smartsheet. For the same project, hours logged is in Toggl, I want to fetch total hours logged against the project from Toggl and display the same in Smartsheet dashboard. Can you please suggest how to implement this.
-
Capture the Decline Reason for DocuSign to Smartsheet
Hello, I am trying to use the Smartsheet DocuSign integration to keep track of the signature status. I am able to track the overall status, such as sent, delivered, completed and declined. However, when a signature is declined, DocuSign will require the signer to provide a decline reason. However, I am struggling to find a…
-
Datamesh - blanking mapped columns
In Datamesh, when the lookup value in the target sheet is blanked out (delete) or even changed to a value that has no match in the source sheet, all the mapped columns in the target sheet remain with the previous value which makes the data not consistent. Is there a was to blank out the mapped value if the lookup value is…