-
Isolating Reports & Linking from sheet to sheet
We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column of subs that I have linked from the data base and then a column (checkbox) per job. Then the superintendents will go to this…
-
Reports pulling from formulas
I have reports calculating off multiple workflow sheets based on a column in the worksheet with formulas - the reports sometimes appear blank and when I go into the worksheet to see why, the formula column shows as blank and then reappears - almost like they only recalculate when looking at the sheet. the fomula is a…
-
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…
