-
Parent/Children Flag Formula
Hi all, I'm trying to create a formula that will flag a child row if a certain date is within a # of number of days, but I'd also like it to flag the parent row if any of the children row are flagged. I am currently using these two formulas: for the parent row - =IF(COUNTIF(CHILDREN(), =1) > 0, 1, 0) . . . and for the…
-
How do you see which reports are connected to a sheet?
Hey everyone! I am trying to track down all of the reports that are connected to a sheet. I am planning on rebuilding the sheet but know that it is connected to a lot of reports that other people in my company use so I don't want to miss anything. Is there a way to pull a list of all reports that have this sheet as a…
-
Report not showing data from a sheet
I created a new smartsheet with data. Then I have added this smartsheet to an existing report In the report i can choose columns from my new smartsheet but they are all blank. Please advise?
-
Formula that will update the new Year dates
Looking for a formula that will automatically update my reporting dates to 2021. Start date is the first day of the month, end date is the last day of the month. Quarter dates are based on first day in January, last day in March, ect.
-
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in dropdown
How to use COUNTIFS with HAS and match 2 Columns while counting multiple selections in multi select dropdown ? Solving for: How many "Devon's Corner" Leads do we have by Location Type - "Bar" or "Brewery".. If any or both of these options are selected, they should be counted as 1 =COUNTIFS({Brand Type 1}, "Devon's Corner",…
-
How does everyone feel about the new report builder?
Wondering what people's thoughts are regarding new report builder, ease of use, etc.
-
Formula help to return differnt conditions
Hi I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below. If all cells return Completed then return "Completed" If all cells return Not Started, then Return "Not Started" If all cells…
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
New Report Publish Current User Not Working
I Published a (new style) report using Access Control-Only available to Users, however, it continues to show the view the publisher sees. The report is Filtered to Current User on a contact column. This help file seems to indicate that it should show the Current User view:…
-
Some feedback on the report filter changes that others may want to add on to
Logging in today I saw that the report filters had undergone some changes. At first glance, it looks great. Upon actual use though, a certain issue arose quickly. This is mostly due to the formatting of the filter selection window drop down. Column headers are cut short with nothing to show the full name even when the…
