-
Issue (or task) list, associated with a project
How do you guys manage issues for a project? I'm wondering a way to attach (or associated) a issue (could be task) list at a project sheet level. Thanks!
-
Column Properties: Not Able to Select Any Standard Option Other Than Check Box
Hi, I have a project queries management smartsheet and one of the Column Titles is "Done". I had chosen "Checkbox" as type of COLUMN PROPERTY. Now I have changed my mind and I want to change the COLUMN PROPERTY from Checkbox to DROP DOWN list. When I right click on Column Heading, I don get EDIT COLUMN PROPERTIES option to…
-
Changing the Color of a Parent Task Bart in Gantt Chart
Smartsheet, It would be nice to be able to change the color of a parent task bar in the Gantt Chart. What is the reason for not being able to do this? I did find a comment (https://community.smartsheet.com/discussion/cannot-format-milestones-summary-bars) that says if dependecies are turned on, then gray is the default…
-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
Tasks in Project Plan are now out of order
Hello, My team and I have been updating a Project Plan that consists of over 1000 tasks in SmartSheet. When I opened the sheet this morning, all the tasks were out of order. The tasks still have the correct predecessors, but they are not displayed in the original order. How did this happen and how do I fix it? Thank you,…
-
using IF together with AND
Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete" I have got "in progress", "overdue" to work by the following: =IF(TODAY() <…
-
Tableau Online vs Server
Looking to link a Tableau dashboard to my Smartsheet dashboard, but according to this link we have to use Tableau Online. Will a link to Tableau Server also work? All my testing is giving me an error for invalid URL so asking here. We don't use Tableau Online due to it being outside our firewall.
-
Value between dates
Hi Everyone, New smartsheet user here, I am trying to get a total cost between dates on a running construction schedule. I have different row-categories (Land acquisition, permitting, site work, construction, & selling) with columns showing start date, end date, and cost. All costs are positive, revenue (selling) is…
-
COUNTIF between Dates
I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my current one. If it is not clear from the formula, I'm trying to count tasks assigned to…
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…