I am brand new to this and am exploring smartsheet. We have a team of ten. We have about 12 projects. Each project is managed by various individuals among the ten of us. Some projects have two people,…
Hi there, I'm trying to count the number of projects according to their traffic light status across about 7 sheets. Given I want to display this in Sights as a Metric, I can't use a report so I have a…
Hi All, I use Send update request to email alias that automatically creates a JIRA ticket. However the Open Update Form Button - is not linked in the JIRA ticket description ? Any ideas how I can get …
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have …
Hi I am currently working in a team where many projects (not necessarily related) are running alongside each other. We would like to create a smart sheet master template/dashboard that allows the proj…
Can you create a generic project schedule in Smartsheet? For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and end…
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever…
Hello - I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a paus…