-
Do Not Include Comments in Export
I need to schedule an Excel file to auto send from a report to a client, but I do not want the Comments tab to be included. Is there a way around this? thanks,
-
Prevent column name from showing up in Sight
Hi, Has anyone found a way (or is there a way) to prevent a column name from showing up in a Sight? For example, I have a report on my Sight and a row in the report is actually the column name which is different than the Smartsheet column name (Smartsheet column name is "First Name" but the row showing the name is only…
-
Count only outstanding items
I have a Request Management sheet with a Form that we used to track tasks. They template came with a Metric sheet that is very useful. One of the metrics on this Metrics sheets counts items by assigned person. I want to update that to count only items that are not Closed status. Current formula is: =COUNTIF({Request…
-
Report Building
Hello, I am trying to build a report on Smartsheet using multiple sheets. Each of this sheet has atleast 30 rows. Is it possible to select rows while building these reports ? There is an option to choose columns. Howeever, I do not need all the rows present in the sheet. Is there any way to do the same ? Thank you
-
Problem sorting report based on "Assigned to" (Contact List)
I am working on producing a report which pulls from a Task sheet (database) based on certain specific tasks and specific statuses. Each task has an "Assigned to" cell which contains a restricted list of contacts (our employees). I have been asked to sort the resulting report by the "Assigned to" column first, and then by…
-
SmartSheet / ServiceNow interface
What is the interface between SmartSheet / ServiceNow and can it be an automated rather than a manual extract which can be extrapolated into reports from Smartsheet?
-
'Find & Replace' functionality in SmartSheet?
Is there a way to use a 'find and replace' functionality across the entire estate of worksheets through utilising Dynamic View coupled with Reports?
-
Reports with Gantt Chart
Is there a way to create a report from a project plan that only shows the gantt chart? I don't want any other information than a visual of the gantt chart.
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…