-
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…
-
Simple IF OR Formula
Hi, I would like for the 'Invoice to Cust' Column to update to "No" WHEN 'Cost Recovery' is either "Blank to Invoice" OR "Operation to Invoice". ^Apart from this, if it is doable; I would like to add to this formula of WHEN 'Status' is "To be Invoiced" will update 'Invoice to Cust' to "PENDING" However, if the last ask is…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…