Sign in to join the conversation:
Hi community, I'm making a bar graph which shows information in %, so each bar is the percentage of the information I want to show, but this '%' comes from a scalar number which I also want to display. Is there a way to do this? I attach an example.
Hello,
Try editing the chart to include the data labels under Series (check the box next to Data Labels).
More information on charts in Smartsheet is available in our help center: https://help.smartsheet.com/articles/2476691-compare-live-data-with-a-chart#format
Hello, I am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…
I seem to have an issue only if I'm using the default Start/Finish columns in a project plan template with a formula. I need to have a Start date X days after Go Live but it won't accept that a formula is a formula when I use the template columns but it will work if I create my own data column. Here is the formula: =([Go…
I Am using the below formular in my Health Indicator but even though my project is on track My overall project indicator is showing Red. What have I done wrong any assistance please :-) =IF(AND([End Date]@row < TODAY(), [% Complete]@row < 1), "Red", IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY(1), (TODAY(1)…