-
I want to add an "OR"statement
-
Is there a limitation for current user selection in reports?
Hi, I have not found any info on this in the community or in the help sources. Before I start to implement reports and dashboards with the "current user" feature, I would like to know if there is a limit to the count off concurrent users accessing the same report at any time? Greetings Stefan
-
Dashboard Report Widget: Columns Content and GANTT aren't in the same line
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is only when presenting in the widget. Is this a 'feature'? Thankful for any help
-
Dynamic push of data into Excel from a Report
Hey guys, I need some help as I 'm trying to automatically import some data from a specific colum displayed in a Report into an Excel spreadsheet and I don't really know how to do it... Here's the steps I've followed in order to have the data displayed dynamically in my Excel spreadsheet : #1 - I've created a report in…
-
How do I create an automatic updated sheet, that pushes information from other 2 smartsheets?
Team, I know you can do it. I have two databases (same structure, different information), but I need a third that consolidates the two previous. If anything gets added in the sources, it needs to be automatically added in the third. If anything gets UPDATED in the sources, the third needs to get updated.
-
Custom Report Format Possible?
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way. For instance if I have the columns and 3 rows. * Publish Date * Category * Title * Body Text…
-
Report | Date column showing time stamp in column title
Does anyone know why this is happening? I have many date columns in this sheet and for some reason this one (Store Closed Date) is showing 7:00 am?
-
Total Count for Specific Date Range from another Sheet
I am referencing a seperate SmartSheet that I have Admin rights on. I want to count the number of items listed within each specific date range was work by. I would like to then find out how many of those items have been completed. I have been trying to work with the following formula but it keeps bring back "0".…
-
COUNTIFS with Cross-sheet references
I'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column next to status called 'Concluded' to evaluate whether or not the ticket's current…
-
Countifs project status is neither complete nor cancelled
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I have other working formulas, but this is out of my expertise. Here's what I have so far.…