Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi community:
How can I use %Plan vs %real (Advanced) in a Smart plan?
Hello,
To set up a percentage column, create a new column and make sure it is a Text/Number column. Then, click the column name to highlight the whole column, and choose the Percentage button from the top bar. (Read more about Formatting Options here.)
You can create two of these columns, with two different titles: "Planned %" and "Actual %".
If I misunderstood your question, and you were asking about how to create a baseline view on your Gantt chart, then I have a brief summary of how you may want to do this:
Though we don’t have any programmed functionality for baseline, an approach many customers take within Smartsheet is at the beginning of the project, create 3 new columns ‘Baseline/Planned (or Original) Start Date’, ‘Actual Start Date’, and ‘Date Difference’ which is a text/number column.
These new columns won’t be used in the Gantt Dependencies so they won’t change as the timeline changes. Highlight all of the dates in the Start and End Date columns then copy them to the Baseline columns.
Create a formula in the Date Difference that subtracts the Baseline or Planned Start/End Date from the Start/End Date to give you how far off you are from the Baseline. You can check out the template called "Smartsheet Formula Examples” in the Template Gallery for formula syntax and samples.
If you were meaning baseline, please also submit a Product Enhancement Request.
Thanks!
Genevieve
Hi, I would like to know the rationale behind not allowing users to access Automations or Forms while in Board View. Many of our sheets are defaulted to Card View for easier viewability, but being unable to access automations or forms from there means I will need to switch back and forth between Board and Grid view…
Hi, I have a very simple automation set up where if the box is checked, change the dropdown column for that row to COE Team. I tried it and it didn't work. I waited for about an hour to see if it was taking a long time but it still is not working. There is no formula involved with the automation so it would be a manual…
I was archiving critical accounting data from one sheet to another by moving the rows. This is something I've done countless times in the past decade of using Smartsheet. This time, after moving nearly 3500 rows of data, I realized none of the attachments moved with the rest of the data. I've opened a case but have had…
