Hello, I am trying to chart this data as a bar chart:
but when I try to visualize it, I get this weird error without any explanation about it:
What should I do?
You have to have numbers to chart. What exactly are you trying to chart and how?
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
I want to chart a time series with that shows for each date who many audit results there are for each date
Thee dates will be the the x axis and the results will be the y axis and it will show number of times the results were chosen.
like in 08/11/23 a bar with "Incomplete - in process" 2 times
You would need a separate sheet that has each date listed down a date type column. You would then have a separate column for each of the different statuses and use COUNTIFS with cross sheet references to get the numbers generated. Once you set this sheet up, you will be able to use this metrics sheet to generate your chart.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In the Second Smartsheet, I need formulas in the individual column row fields to look up and match the value in the IDUn...…
Hi, I am trying to calculate duration and I have tried every formula I can google leaving me with unparseable or incorrect argument set... the fields I am trying to use in my metric sheet are "Actual Start Date" and then TODAYS date. I currently have several variations of this =IF(TODAY() - [Actual Start Date]@row)) or…
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
©2024. All Rights Reserved Smartsheet Inc.