-
Can a duration column with dependencies not pull data from a created date column?
I have a sheet with a created date that is generated by the system upon submission of the project. I wanted to create a column that tracks the duration of the project from submission to delivery with dependencies, but when I click the drop-down under project settings it doesn't have that created date listed. Is there a way…
-
Find middle number using LEFT and RIGHT Formulas
I have a column with dates that look like this 2022-10-18. I am trying to create a formula using LEFT and RIGHT to only give me the month (in this example = 10) Please help, thanks!
-
Adding Condition to IF Statement
Hello! I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID…
-
Actions Button for Slack Integration
I am recently working on a workflow while utilising the slack integrations, particularly with notifications. However, I have seen that there can be actions set as part of the slack notifications on the smartsheet site (more specifically action requests (decline or approve)), but there is no indication this process can be…
-
Integration of Mathematica and Smartsheet
In this article, we highlight interesting achievements with the integration of Mathematica and Smartsheet
-
How come linked tickets under the JIRA Epic does not pull into my smartsheet but only child issues?
Hello! How come the linked tickets under the JIRA Epic does not pull into my smartsheet but only child issues pull in? Is there a way to have all tickets tied to the EPIC pull in? Our PROD/ENG sometimes have tickets that were created from someone else but then finds out it relates to the EPIC, so they link it. I want to…
-
Transitioning Existing Smartsheet Integration to Microsoft 365 GCC High
An existing client makes heavy use of Smartsheet integration with their current Microsoft 365 commercial tenant. They have some Power Automate / Flows built around this integration. They are exploring a migration to a Microsoft 365 GCC High tenant and I wanted to clear up a few questions regarding Smartsheet before making…
-
Data Mesh scheduling - new row in the target sheet
I have a configuration with Execution Frequency = Immediate and Data Mapping Format = Create Cell Links. When I add a new row to the target sheet, mapped cells do not get their link in the new row. If I change the schedule to 1 Hour, links are added. Q: If all my mapping is Create Cell Links, then I don't need a frequency…
-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
-
Update one sheet using Power Automate on several Excel files?
Hi there, I have a use case where I have a bot creating Excel files daily. I'd like to use Power Automate to tak the data from those Excel files and add it as rows into an existing sheet in Smartsheet so that I can add workflows to the data in those rows. I tried setting up a flow in Power Automate, but was stuck on two…
