I have a picture of what I want to do, but can't with the selected data set. I tried, but it said data cannnot be charted. I selected the data range primary and status.
I use a metric sheet to roll up some of that data, and then pull my chart from the Metrics. You would pull it as data (a number) and then in the chart widget, you would color it there.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.