-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…
-
JIRA Integration: automatically clear completed issues?
Hi Smartsheet Community, We recently integrated JIRA to Smartsheet and are trying to limit the information that flows into Smartsheet. Our goal is to plan the roadmap based on all incomplete tickets (Issues) in the backlog. This means that we don't want to see completed/resolved/done tickets in Smartsheet. The way we set…
-
Assessment Tools
Do any community users use any kinds of assessment tools in smartsheets?
-
Upvote for Gantt Chart by the Hour
Can I upvote for the Gantt to include feature by the hour? We're coordinating with many subs in every 15 throughout the day and we'd like to be able to track delivery activities by the hour (or every 15 min). In the meantime, we'll be using the calendar feature on Outlook to track these activities.
-
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
-
CAB Change Advisory Board
Anyone has an idea of CAB template/format. The company's requirenemnts is to track and report on tickets in their current review, approved/rejected/deferred. Status of in progress or completed. CAB takes place twise a week so the date of CAB is imprtant for historical purposes as well. It is not difficlut to create in…
-
Editing the automated response email
How do I find/edit the autmated response email (sent whenever anyone submits an application). thx!
-
How to define a default value for a field with a formula
Hello Guys, I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date. f(x)=NETDAYS([Created Date]1,[Closed Date]1) The formular is working…
-
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
-
How do I configure Skype integration?
I'm wondering how I can configure and/or take advantage of the Smartsheet integration with Skype. There was a YouTube video posted about the integration on May 6, 2016, however I haven't been able to find any documentation or help on how to actually set up, and use this functionality:…
