-
Past Due Reporting
Is there a method to have a report that generates past due tasks? On our task management sheet, I have a ‘due date’ and ‘date completed’. Once a task is finished, my team members will input the date completed. If the date completed extends past the due date, I would like a report to be generated and available to the…
-
Renaming a Report through the API
Hello, Is there a way to rename a report through the API? Thanks, Nathan
-
Smartsheet API report creation
Hi, We have a lot of reports, they have only small differences. Normally it is just a filter e.g. name of "assigned to". If we have to slightly change these reports, we have to change all the reports by hand. Is it possible to create/change reports with the API? I tried to do it but i did not found it in the API…
-
Countifs with dates
Hi I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong.... =COUNTIFS(Created:Created, >= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content…
-
Identify all reports using Data Field
I need to change column header names on a sheet which is going to break reports. How can I identify all locations that the data field is used.......reports, metric, etc.?
-
Full year calendar - accounting month/quarter end
Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to see this in a calendar view Any suggestions on how to build this? ie: Formula for the 'due date'…
-
Filters on Reports
I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added to the future enhancements list. Thanks, Steve
-
Count Rows from a report, not sheet
It would be great if Smartsheet could provide a count of rows in an already generated reports, and if that count could be cell inked to. This is not the same as criteria based counting in a sheet, which is great unless you are trying to use lots of variable discrete criteria.
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
SIGHTS - Error: "Source report missing" in Report widget?
In a Sight there is a section where a project plan is shown via report widget. Source is a report based on a project plan. It worked well until today... All of a sudden the plan in the Sight is gone, although the source report is still available and showing content correctly. Since I had no idea for the cause, I tried to…
