-
How to make Gantt bar color dependent on condition: if a task is a child (subtask) of a selected par
I have created a sheet based off of the Team Task List by Priority template. I have changed the priority task names to reflect the names of our team members. This allows me to group the tasks by tech, so the sheet's description would more accurately be Team Task List by Tech. I had conditional formatting set up to…
-
Outline level field
I'm an (expert) Excel user, using Smartsheet now in our organisation for basic tracking functionalities. It's a daily 'struggle' to understand the limitations of Smartsheet and try to keep the sheet basic and simple, but I'm quite enthousiastic about Smartsheet. On the other hand, I really miss some (in my point of view)…
-
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…
-
Parent Date Roll Up
I currently have a sheet where i have multiple columns with dates thats that are going to need to roll up to the project level parent. I am looking for a way to roll the dates without using the predcessor function as it doesnt quite work right. In the picture below you can see some of the columns. I would like to have the…
-
Conditional Formatting
Is there a way to apply conditioning formatting so that the result happens to the parent row if the condition in the sub-task row is met? As an illustration, if a due date is not marked completed within 30 days, I'd like the parent row, not the sub-task, to highlight. I use sub-tasks so that I can keep them all collapsed…
-
Conditional formatting not always working on "Modified (Date)" column.
I have a status sheet that is picked up in a Sight. For ease of recognizing updates, I use condirional formatting to change the text color on items modified n the last few days. This worked well initially, but now the formatting is not always being applied. The same text column is updated all the time. Not sure what I may…
-
Smartsheet Merge for Google Docs
Has anyone successfully used conditional formatting (i.e. if/then statemnets) within smartsheet merge to google docs?
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…
-
Conditional format using two columns
Hi, I have two columns Planned start and Actual start. I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start. Please assist. Y
-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
