-
Basics of Webhooks from other applications via SurveyGizmo
Hi, I am new to attempting to work with these Webhooks and could use some help. I use SurveyGizmo as a surveying tool to gather information from a large amount of users. I am trying to build it to where everytime a response is made in SurveyGizmo, it will transmit that data to Smartsheet to store on a sheet. SurveyGizmo…
-
Help with formula to avoid #DIVIDE BYZERO ERROR message
Hello, I have a large formula trying to achieve an AverageIf function - but I still sometimes get the #Divide By Zero error - any ideas of what i can do to the formula to avoid this? =SUMIFS([HEP Time (Minutes)]:[HEP Time (Minutes)], [HEP Name]:[HEP Name], "Galvin Davidson", [Current Month]:[Current Month], 1,…
-
Search functionality - returning matches on subset of a search string. Also, wild card usage is non
It appears that Search is not working correctly. Please review the Search functionality and also the use of wild cards. 1) The search results will include matches to the full search string but also to any 3+ characters within that string. For example: A search for beets would return a results list that would include beets…
-
Salesforce & Smartsheet integration - executing workflows via API
Hello All I'm now investigating Smartsheet & Salesforce connector. I configured "one-direction-only" data synchronization from Salesforce to Smartsheet. It works pretty well - once you hit "Run" button on the https://connectors.smartsheet.com/c/salesforce page. Now I wonder if it could be possible to start synchronization…
-
Salesforce & Smartsheet integration - access to other users' sheets
Hello All I've configured the integration between Salesforce org and Smartsheet account. During configuration process I provided Smartsheet account with SysAdmin priviliges (this is required step). Let's call this account "TEST_Smartsheet_admin" Now I'm logged as regular end-user in Salesforce and I'm trying to add…
-
resource-based Notifications per line item
Hi community I recently created a sheet which employees in our company can complete through a webform. I was wondering if it is possible to send a notification to one of our team members in case a certain field is chosen (dependency driven notifications). For example, if a record is added by an employee and one of the…
-
SmartSheet Powershell Module proposal
Hello, After having spent some time on this, I am just wishing to share this to anyone willing to use the powershell module I have written. I did this on top of my work, and I might not have time to update or bring correction, but I use this module for my own work. It uses .NET framework and I run with powershell V2. I did…
-
Emails not working
Since the new update we have found that sending update requests are not going out to email addresses within our company org - anyone else find this problem?
-
New update has broken reports, cell drop down lists are gone
As of this morning, dropdown lists no longer work in any of our reports, only the main sheet. This is a major problem...any ideas what's going on? Logged out and logged back in several times, but to no avail.
-
Dec 10 Release Notes
There are no release notes (yet) for yesterday's release. https://www.smartsheet.com/release-notes I was hoping to test new and existing functionality today. Also: November's release isn't listed here: https://www.smartsheet.com/product-roadmap Craig