I've tried copying a similar graph widget, then changing the source columns, but only 1
of the 2 Y axis data sets appear (X axis is the date).
Have you checked your main setting for the chart?
Thanks for the reply, and yes it is there. That's what is so puzzling that it doesn't show when i look a the Series data
Try turning it off so that it does not use the first column for the series labels.
no...just figured it out. It was because in my formula on the Sheet, I had: IF( Between Date x and y), "98"... I had the number in brackets which was interpreted as text....rookie mistake!
Thanks for your help though
Yep. That'll do it for sure. Glad you were able to catch it. 👍️
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…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello everyone, I'm wanting to run a workflow once every three months. If I set the trigger to be the first Monday of the month, every three moths, and starting today, will it trigger in three months' time on the first Monday? Or will it trigger next month's Monday (assuming this month's first Monday has already passed,…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.