=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…
I can't remember exactly how I used to do it but I'm sure the old style smartsheet was easier than trying to do it now. We hadn't been using it long before the change. The process I'm currently using …
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent b…