-
Conditional Sheet Population
Is it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some products are not elected by a client and therefore we do not have to track their related…
-
Card View for Reports
All, Has there been any progress with adding card view to reports? Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to view user stories across multiple products/sheets. Although there are other benefits I…
-
Card View for Reports
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
-
#DIVIDE BY ZERO Error - other resolutions not working
I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using: =ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0) I tried the IFERROR(ROUNDUP resolution and that…
-
Auto create multiple sheets for one project
Hi there folks. I'm fairly new, so this may be a fairly basic question. I'm using Smartsheet for project management, I'm in the planning and intake team. When we intake a new request and it's approved, I need to then create a project from that request record. When I create this new project do I need to manually create a…
-
Expand/Collapse rows
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
-
Is it possible to develop a task list from multiple source sheets through automation?
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end. We have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and…
-
Triggering a Workflow on existing data
Hello, I can't seem to figure out how to trigger a new Workflow on an existing data set. I created a Move Row Workflow that is triggered by a change in my Status column and where there is a date present in another column (two conditions). I am having to change the Status from Completed, save it, then change it back to get…
-
How to best pull data from a matrixed sheet of dates and milestones into a project sheet?
I have a team that is updating date estimates in a large sheet. I'm looking to create a project sheet from that matrix/range. I'd like generate the sheet with links at the same time so that when the team revises dates in their sheet the project sheet updates as well. I don't want to have to manually create Column A entries…
-
How to count the times a person is assigned to a defect status
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
