I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' day…
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all…
The new look/functionality of the sheet is much less friendly. Takes a lot more clicks to get through and I now always have to close the left pane to see my sheet properly. Also, the left pane list ke…
Hi, I am new to Smartsheet and I am trying to create a view for my team where I can see all of the tasks, across multiple sheets (projects), that individual team members are assigned. In other words I…
Hi there:) I have a sheet used as a "Maintenance Request" sheet. It is populated by a form. Each person submitting a request provides their name/email into the "Submitted By" column. This allows them …
I am an admin user. I updated a sheet with multiple rules. The rules show up the sheet when I open it. But, when one of the other users on our account open the sheet, it is missing 4 rules.
Our security certification requires that we provide answers to several key security questions for every project (risk assessment, project justification, etc) and I was wondering what the best way to h…
Here's the situation: I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estima…