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:
Is there a way to set a dynamic column to be the % Complete column for the purpose of setting the Task Completion bar?
All help is appreciated.
Hi Ben,
To accomplish this, open the Project Settings on the sheet and set the % Complete Column drop-down list (under Options) to reflect the column you've assigned as the % Completed Column.
If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I would love some help troubleshooting a column link issue between two sheets used for department metric scorecards. Sheet 1 (source sheet) is the metric submission sheet where metric owners report quarterly data. Sheet 2 (target sheet) is the scorecard that shows quarterly goals and actuals, with a status symbol for each…
Hi all, Question: What makes cell formula update/populate a value and why would there be a long delay? Here's my issue: I noticed a request was stuck in my workflow, and when I reviewed the cell history on the helper columns I noticed the culprit was a cell with a relatively simple formula that didn't populate a result…
