-
Is there any way to respond to an @mention directly from Microsoft Teams chat?
When receiving a tagged mention notification in Teams, it appears the only option to respond is to open the Smartsheet and reply there. Is it possible to reply back to the chat message and have it flow into the Smartsheet comments (i.e., like it does with the "reply to this email" option in Outlook)?
-
Formula to add multiple names to one cell
I need to create a lookup to select multiple names from 1 sheet and add those names to 1 cell in another sheet: Sheet 1: (names in multiple cells) Name - Type Rick - A Jane - B Bob - A Sheet 2: (put qualified names in 1 cell) Lookup names = 'Type A' and copy them into 1 cell. I know VLOOKUP or an INDES + MATCH can find a…
-
How can I tell if a report is a Dynamic Scope Report or just a Report?
Hello, I've tried searching for this question but was unable to find the answer. By looking at a report, is there a way to determine if it is a Dynamic Scope Report (i.e. pulls in new projects as they are provisioned) or a static report that someone made using various reports from different workspaces (not controlled by…
-
How to connect Smartsheet to AWS Redshift
How to connect Smartsheet to AWS Redshift ?
-
Dynamic View - Commenter Role
In the dynamic view, if it is set to "restrict view by current owner" and that owners permissions get changed from Editor to Commenter, will they still be able to see? Someone in my organization did this and it might be affecting who can now view those items in their dynamic view. Could there be a correlation? Thanks.
-
Can Allocation column be tracked by hours?
Hello, Currently, I am tracking Allocation as a percentage within Smartsheet so that the data can feed over to our Resource Management account. I want to know if calculating allocation based upon hours is possible because the worklist within Resource Management is unclear with allocation as a percentage. Please let me know…
-
Where to get the Scope Object ID
I am building an extension for Zoho's Cliq app, for creating a webhooks I need ScopeObectID, so can I know where to get the scopeobject ID attribute https://smartsheet.redoc.ly/#operation/createWebhook for webhook creations.
-
Data Shuttle - Changing my 100% to 1%
Hello! I've created a workflow using Data Shuttle to take values from a Excel sheet and import them into my Smartsheet. I am running into an issue with any cell having a value of 100%, as they are getting inserted into Smartsheet as a 1%. All other percentages come through just fine, including with the 2 decimal point…
-
Changing my appsheet data from google sheets to smartsheet. How to include multiple tabs in
Hello I'm new to smartsheet and still learning how everything works. I already have an appsheet app set up in google sheets but I want to change the data over to smartsheet, so everything is in one place. I notice smartsheet doesn't have the ability to have multiple tabs? How do you transfer the multiple tabs over to…
-
Jira Connector Error Message
I am trying to set up my Jira Connector and am receiving the following error: "Invalid response from JIRA, statusCode: 400, reasonPhrase: Bad Request Could not find issue by id or key". We have the Issue Key set up to send from Jira to Smartsheet. Can anyone point me to a troubleshooting guide with the status and reason…
