-
Formatting Sheet Summary Reports
Enable formatting in sheet summary reports. E.g changing text size, bolding, colour, move value to centre etc. Currently sheet summary reports look sloppy, requiring time consuming work to add the values as metrics to dashboards if you want them to be presented well.
-
How do I gather and display info for this dashboard widget?
Hello Everyone! I have a dashboard that is tracking the progress of several projects. My audience had requested a visual representation of where each project is in the PM Phases Initiation, Planning, Execution, Monitor and Control, Closure I have created a sheet summary report that shows in words where each is is but they…
-
Add Grouping to Report Exports
When exporting a Report to PDF or Excel from Smartsheet, grouping and summary rows should be included. As I utilize a lot of automated reporting, via PDF, this would create consistency in the report view and exported view.
-
SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
-
When the CopySheet API responds, is the copied sheet really fully created?
I am synchronously using the CopySheet API to make a copy of a sheet. This API responds with a sheet summary, which itself includes the copied sheet's id. Immediately when that sheet is copied, I call the GetSheet API to get the full details of the new sheet. Mostly this works, but a moderate number of times, I will get a…
-
Business Plan features for a single license
I love Smartsheet's features. When I left my corporate job to strike out as a freelancer, using Smartsheet as one of my primary management tools felt like a no-brainer. Unfortunately there are some features I want to use (e.g., grouping on reports and sheet summaries) that are exclusive to the business plan, which has a…
-
Allow editable formatting in automated emails
It would be great if similar to a document generator, we could generate an email template. One example I have attached where it shows "1 row added or updated (shown in yellow)." It would be great if that was an option to enable or disable some of the email elements or have my own format filled out with information in my…
-
Column Formulas Display Forms
We have a Control Center solution and forms that are tied to RAID logs and more. We have no way on a FORM to automate a project name or ID We would love (like on Card View) for a Column Formula to show static information on the form that pulls from the sheet. OR the option to pull Sheet summary data to the form. This would…
-
Smartsheet Summary Counting Assigned to with multiple people in the field.
I have the sheet below and I want to count for each person how may items are pending their approval. The formulas I have tried only find where it is only one person in the column. Where there are two people in the column it ignores the column. I have tried =COUNTIFS([Pending Approval From]:[Pending Approval From],…
