is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
We use a separate gantt timeline for every project. We also use a simple grid to capture to-do tasks not relating to any specific project. We want to be able to view all cards from all projects, on on…
I have two dates: A and B. B's start is dependent on A's completion. If everything goes as planned, A will finish on 2/27 and B will start on 4/1. B's start date is constant unless A's finish is delay…
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * (…
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following …
I could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN stat…
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that t…
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respec…
