-
Sumifs and Children
I am trying to sum the values of child row if three conditions in adjacent columns are met, from another sheet and post it on my main sheet. I reference a parent row and need to sum the children values if they meet the three conditions . Specifically, I use a cell value from the main sheet to find the referenced parent row…
-
Smartsheet Python SDK Pyinstaller
Has anyone had success packaging their python applications for smartsheet into executables with pyinstaller? I've tried adding hidden imports, updating spec file, and running a clean venv with python 3.4 yet I still get an error message the second the program gets to the object associated with smartsheet. It states that it…
-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
-
Allow Multiple Contacts Per Cell
How do you uncheck allow multiple contacts per cell from the Assigned To Column Properties? The checkbox is marked and disabled. Having this checked has also limited the Card View where now I can no long view Cards by Assigned To
-
Notifications work for me but don't work for additional emails in cell
Hi, I'm having issues getting notifications to work. I have line items where there are multiple emails in a cell. I have it set up when a date changes, a request for notification goes out to the emails in a designated cell. The emails go to me when I'm the contact but when there are other contacts in the cell, those emails…
-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
[SmartSheet-Jira] Few basic workflow queries
Hey Guys, I started to use the JIRA connector for Smartsheet and run into some basic issues while creating the workflow. Idea here is I want to create the Jira tickets (Epic, Story, Sub-tasks, Bugs) from Smartsheet but need 2-way sync to keep updated everything on both the places. Query 1: during the workflow setup, I…
-
Access of a Report via Dashboard
Background: I have created a form to capture Company personnel’s proposed ideas to improve cost savings, quality and safety. With this I have also created a Dashboard to give a snapshot of the progress of all Idea’s submitted. On the dashboard I created a button that I had intended for a person without a Smartsheet sign on…
-
How Smartsheet define, handle and monitor allocation on teammember
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…