-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
Merged: Ability to set font size in report
This discussion has been merged.
-
Email alerts on reports?
We have 100+sheets that I have rolled up into a single report that contains due dates for tasks. I would like to be notified if any of those due dates are not met, without having to set an email alert on each of the underlying sheets.
-
Use report count value in dashboards
Hello, I am new to Smartsheets. I have tried searching in the forums, but couldn't get a resolution. Below is the scenario. In Folder - Project Type 1 Project 1 Project 2 Project 3 Using Summarise function of a report, I can get the count of number of projects in each folder. Can I use this count value in a Grid or…
-
Reports in Collections
I have reports in a Collection that include sheets that are not shared. I do not see rows in the report from sheets that are not shared even when I'm sharing the Collection. How do I get around this?
-
Can I export a sheet's shared users list?
Hi, Is there a way to export the users shared to a particular sheet with the user information (name, email)? I don't need the whole account. Just a specific sheet.
-
Weekly Reports - Best Practices or Tips?
We need to send weekly reports in one email that pull information from a few different reports. We have it all on one dashboard, but I don't know of a way to send dashboard summaries by email. And they don't want to go to Smartsheet to view it there - it's got to be in an email. Ideally, they want the information in the…
-
"Submitted_at" in a report that can be pulled at any time
Right now "submitted_at" the time that a resource submitted their timesheet at is only located in the audit log. The audit log can only be pulled once a month and is not an advanced report that can be pulled into SmartSheet. My team would like the "submitted_at" field to be in the timesheet detail report or another…
-
Combine "AND and "OR" with filtering
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
-
Creating a metrics report - Sheet reference not working/displaying criterion
I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with…