-
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…
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Index(Collect(Match)) Formula Error
Hello all, Hoping someone can help me, I keep getting a "#No Match" error for my formula. I have a neighboring column with top 5 orders and I am wanting to mirror the date that these top 5 occurrences happened (using a date column that already exists in my sheet). My formula is, "=INDEX(COLLECT(Date:Date,…
-
Countifs based on current month turnaround times
Good Morning! I am trying to create a graph based on the current month's turnaround times. I tried the following, but it returns as #Unparseable. =COUNTIFS({Turnaround}, <=3, {Date Fufilled}, Value(@cell) = Month(Today)) Is this even possible? Thanks