-
Using a formula to count numbers of projects assigned to an employee and at what stage its at.
Hello! I've created a sheet to pull metrics from for some charts I need to make and I'm trying to create a formula that counts the number of projects that are assigned to each employee and its progress level. I more or less understand the first part of the formula counting the assigned projects, but I'm stuck on how to get…
-
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…
