-
Formula Help: Count "To Do" for rows with start date in June
I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that start in June for example. How can I add this additional ask for the date? Thanks!
-
Report not including today's date results
Hello, I am trying to get a report where I don't need any information that falls prior to 7 days from today so I have that option selected on the "When" but the problem is that the report is not showing today's results at this point. Any idea how I can automate this? I chose to add another criteria where the date also is…
-
Reports not refreshing, again
Hi I'm finding that reports are not refreshing accurately when the underlaying data, in a smartsheet, has changed (and been saved before you ask). The source data is around 20 rows so this should not be a problem. We have seen this issue previously. It seems to fix itself - i.e. we make no changes and suddenly the report…
-
Moved a sheet and now the data won't show up in reports
I had a full project plan in one folder. Then, I saved as new in another folder and deleted the original. The original plan was showing up in reports just fine. But, the new version will not show up in any reports. I have ensured that the new folder is selected when I build the report. I've even created test reports that…
-
Formula to look across rows and columns in a table.
Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Security concerns with published links
We have enabled the link public publish for our organization's users; however we want to purge or expire these public links after the need is over; because we are sure most users won't remember to toggle the public link off on the sheets or reports. I know there is a report that admins can generate that shows all published…
-
IDEA: Create Cross-sheet references from reports
Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need. It would be great if you could do cross-sheet references from reports. This would allow me…
-
Dashboard Viewing - Send as PDF
There are options to send sheets and reports on a recurring basis, but there is currently NO way to send a Dashboard as an email attachment on a recurring basis. The dashboard link is difficult to view on an ipad or mobile device. We would love to see the option to send a dashboard as a pdf or png attachment to an email on…
-
Renaming Reports - updateReport() functionality
There has been very little discussion on this topic. What is required to get this feature added to the API? I have been assigned the task of creating a JAVA app that will create new workspacea from a set of templates we've created. This is to be done through the JAVA API(SDK). I've completed the app other than renaming the…