-
Dynamic View not Saving
Hello, I have several Dynamic Views set up for different sheets but one is not saving and I cannot figure out why. The sheets are large, with about 4000 rows and 50 Columns, all of the sheets are roughly the same size depending on the amount of submissions they get from the intake form and this is the only one giving me…
-
MSFT Power Automate (Formerly Flow) Connector
I have been testing out the connector that SmartSheet has built for Power Automate (formerly Flow): https://docs.microsoft.com/en-us/connectors/smartsheet/. I am using it to insert a new row into a sheet, triggered when an email is received that meets certain criteria. I am adding information from the email into the new…
-
Errors when setting up JIRA Connector Workflows
I am getting the following error when I try to set up my JIRA Connector workflow "An error occurred while counting the number of rows to be updated." How do I further investigate why I am getting this error. Thanks!
-
Getting the Provision Error
Hello, Hope you are doing well I am creating a Project on Control Center but getting the "Provision Status" Error. I included the Project intake sheet and summary sheet in the blueprint. Please let me know what I am missing in the process
-
How can I activate Datamesh
Morning all Can`t seem to find a website that tells you how to download Datamesh. Please let me know off one or tell me how to download Datamesh Many Thanks
-
After publishing a sheet to Google calendar, can I get the Gcal events to stop updating?
Hello, Smartsheet community. I recently started publishing my Smartsheets to my Google calendar. It's great, but the problem is that I don't want every item on the sheet to appear on my Google calendar. If I delete these items from my Google calendar, the problem appears to be solved. I can also rename Smartsheet items on…
-
Asset Tracker via app search function
I am trying to search for a text numerical field i.e. FC090909 The app will find the field if there is a space in the field between the text and numbers i.e. FC 090909 but will not find the whole string if searched together with no space? What am I doing wrong? Thank you
-
Will Blank Values Map Over in Datamesh?
I have data in a source sheet that changes occasionally. If a field gets mapped over, and then is later deleted in the source sheet, will a blank value also transfer and override that cell in the target sheet? In ex. below, Field 3 gets mapped over and then is later deleted. Will the target sheet look like option 1 or…
-
Pivot Summary based on base sheet hierarchy
I have a running list of rows (touch points) that have a status associated with them. I want to make some charts that aggregate the responses under the hierarchy. For example, The top level hierarchy is "Quality". The child is "Mock-ups". There are 4 questions related to mock ups, each having a status. I want to chart…
-
Executing a SQL Query?
Is it possible to extract data from two sources (Ultipro and Siteline), store the data in a common repository then query off that repository into Smartsheet? What third party app or apps would we need? Any assistance would be appreciated!
