-
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 . . .…
-
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
-
No Array formulas but need work around
Smartsheet does not use array formulas, but I need a way to list out items from one spreadsheet to another if a certain condition is met. For example, I have an array formula that I used in excel that would look for a certain condition on one spreadsheet then pull all the rows of data that had that condition to another…