Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Top Level Task Colors
I am trying to figure out if I can change the colors of the top level (roll up) tasks. It would be great to have a default for this in the "colors/logo" settings.
two way link
Is there a way to create a two way link? By this I mean create a link that no matter which sheet I am on it will update both sheets. Right now I can create the link and I can only make changes on one sheet and the other sheet only sees tthe change.
Linking Sheets and Sharing
We have a sheet being kept up by our quoting group listing such things as customer name, quote number, amount of quote, etc. This includes the sales person. We keep a similar sheet for orders that have been entered. We would like to keep these two sheets separated by group that uses them, and they use some formatting to…
Produce a report for a particular day
Is it possible to produce a report that shows all items from all sheets which are due on a particular day?
Email notification after change a sheet
Hi, Can i set to recive an email once someone have entered a new web form update? 10X
IF(Is Parent Row....
I am using the below to calculate the "days since last contact" and it works nice. However, if the row is a parent I want to retrun blank, i.e. <> =IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, "Never") The formula for check is a parent row is…
View All Users Projects,
Hello, İs there any way to see our licenced users all projects, Even not share to us. Thanks.
Count cells containing string
I'm trying to create a tally of the number of rows where a specific column contains a string. For example, the contents of a cell = "6-1, 6-2, 7-2" and I want this to be counted as 6-1, as 6-2, and also as 7-2. If this row were to only have one designation, so cell = "6-1", I could do this easily with COUNTIF. But although…
Changing the ball color on parent based on color of children
What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.
Adding images to a Gantt chart cell.
Adding images to a Gantt chart cell. Anyone do this?
