Problem: Sometimes my reports have no items as all the actions are closed in the underlying sheet. It is then irritating for my email recipients to receive a blank report. Ideal state: To have two options: Dont send the report if blank or send an automated email still on the recurring schedule stating a custom message…
I'd like to tick a checkbox based on another checkbox being ticked and for a specific task name. I have the following formulas that work individually. How can I combine them? =IF([Checkbox]@row = 1, 1,0) =IF([Task name]@row = "XYZ", 1,0)
I couldn't find an existing topic in Community - When selecting a Report for widgets, it's unwieldly to scroll past the folder system. It would be an immense improvement to collapse folders and only see workspaces within the sheet picker.
Example I have 10 sheets for each client and converted those into reports to get the information in one place. Now to feed the details like count/avg/pivot/sum on dashboard I should convert the report to sheet. because cannot reference the report to dashboard directly. Will there be anyway to shift the data from reports to…
This discussion has been merged.
We've been trying to build some insighful anaylicts for our leaders and I would like to show consumption (views) of dashboards and sheets, but I want to be able to separate internal users from externals. This analytic is a bit manual since when downloading the Activity Log, I'm not able to separate all the internals from…
I've noticed a discrepancy in the displayed dates between two Smartsheet sheets, despite having checked for common reasons like date format, timezone settings, and data entry errors. What other factors should I consider to troubleshoot this issue effectively?"
I'm new to using control center and I have an internal team that wants to use it to create client specific reports and dashboards in addition to our internal information. The problem is there is certain information on the sheets that I don't want the external client to have access to, so I can't share a report with them. I…
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked. For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to…