-
Build Gantt Chart based on JIRA User Stories Story Points estimations
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story points = 3d 3 story points = 5d ... Theoretically it is possible to build a gantt chart of the N user stories as follow User…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval action
When requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when determining the action from that approval. I have to create a separate workflow based on the population of the approval column.…
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addresses * The specific problem is that even though the name or email address values in the file…
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
-
Can I add something to color code for blank cells?
Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) This formula works well for what I need except that I use a template project sheet…
-
Save Button For Webforms
Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform all of which have a general response from employees saying this will get added as a possible future update. it has been about ~2-3 years in some cases. As a user community, this is an important function for data…
-
Addition of resources to Smartsheet
Greetings. The previous system admin of our Smartsheet account has left the organisation. How do we change the system admin now ? There is a need to add more resources to our account and we are not able to do the same. Kindly provide suggestions on what to do. Thank you
-
Workspace "cover page"
Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact with the sheets, reports, or dashboards inside? because I could find that useful. :)
-
Product Development Testing Template Set
I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tracking & Submission and Bug Report). I've reviewed it "Create New -> Browse Templates" but…