I've created a report pulling from two sheets. With no filter on, the report pulls from both sheets fine. Once I put the filter on, it's only pulling from one sheet. Advice on what I'm doing wrong?
It sounds like you might be filtering based on a column that only exists on one of the two sheets. Can you check the Column Name that you're using for the filter, and then check to make sure that exact same name is being used on each sheet? See: Select Columns to Display for Report Builder
If the name is identical, then it may be that the value you're using to filter by is only on one sheet. For example, if one sheet uses "Complete" and the other uses "Completed" with a D, then if you filter by "Completed" with the D you will only see one sheet's data. Does that make sense?
If this hasn't helped, it would be useful to see two screen captures of the Report: one with both sheets showing and one with the filter applied (identifying what the filter is).
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…
I have an automated workflow that requests a form if certain fields are blank. It's triggered when a new row is added or changed. More specifically, the automated flow is activated when a required field is added or changed. This works fine. However, the automated flow doesn't issue a follow up form request when some of the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.