Reports
Discussion List
- We have over 500 smart sheets for various processes. We'd like to know which smart sheets have had no activity for the day. Is there an way to create a report for this? Any ideas or suggestions would …
- I have created a sheet that tracks the training status of 20+ team members on ~200 SOPs. Each SOP has its own row and Team members are the columns. I want to draft a report or pull data into another s…
- Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) wh…
- Hi, I have generated my report based on resources, accounts and project status which I am trying to create a chart for but it won't accept the data from the report - any ideas?
- I am trying to show a ratio on my dashboard and would like to know if I could use a function to find the ratio.
- Hi all! I'm trying to setup a formula that allows me to count actions (in red) and that also shows me the weekday in which they were made. The columns I'm using for this are 'S' and 'Action Creation D…
- Question 1: I'm pulling multiple reports together. I can't figure out how to issue any sort of GROUP BY clause. Please tell me how. Question 2: How do I pull Parent/Child meaningfully into a report? I…
- Hi All! Im trying to get the average number of a certain range, but only if it meets a certain criteria. I have looked at other examples but somehow i don't get it to work. So I want the average of th…
- Hi there, Is it possible to incorporate dates in an IF formula? Essentially I want the RAG status to automatically go to 'Red' if the %complete is not 100% and the date is in the past - how would I go…
- I have created a dashboard and added a report to the dashboard. In the published dashboard, the "Created" time is displaying as 3 hours earlier than what the report and Smartsheet is showing. How can …
