-
Sheet Speed problem
I have a sheet we are using to track payments etc with the layout is simple First Col is the Colored dots Red/Yellow/Green Cols 2 to 7 are just plain data 3 are date fields the rest are text Col 8 has the only formula = TODAY() - [Check Date]1 However the issue is the speed of the sheet, it acts very sluggish and the first…
-
User Changes Report
Is there a way to set up one report that shows all changes the user has made throughout any/all spreadsheets in smartsheet on a reoccurring basis (daily or weekly) ? *It would be helpful if the report showed the actual line item changes and not just the sheet link with username, date and time.
-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Reviewing Alerts & Rules for errors
Hi all, I've searched high and low but I can't find a way to do this easily. Is there a way to export all the notifications and rules set up for a sheet for ease of review against the process? Basically I want a report of all my notifications and rules layed out in a table so that I can review them against the process for…
-
upgrade from individual to... individual
Hi! I have an individual plan. When I try to create a report I get a popup window asking me to upgrade to an individual plan, which I think does not make sense. Any ideas on how to sort it out?
-
Sights - can't pull in attachments or apply fill color to data?
Hi, wondering if anyone out there knows if there are work-arounds for some issues I'm encountering with a sight I created that contains data from several reports. Issues are: 1. The reports include the attachment (paper clip icon) column, but this column is not displaying in my sight. I've checked the column settings, and…
-
Show ONLY 1 Project's Gantt in a Sight
I am building a Sight for just 1 project. It has the project's title, an overall report, and then a report that shows just the status comments. The last widget I want to put on the Sight is JUST the Gantt chart for that particular project. How do I show that?
-
Passing values from a report
I'm trying to create a Sight that shows a high-level overview of a portfolio of projects. If the user clicks in the widget within the Sight I'd like them to go to a more detailed report on the project that they selected but only the project they selected - not all the projects in the sheet. Is this possible? Thinking of…
-
Basic Project Management Suite Template
Everyone, I am in the process of creating a set of sheets, sights, and reports to manage the projects for our team. We don't need anything fancy or complicated, just something that will allow us to track our project tasks, project charter information, and a project dashboard. It occurred to me that someone in the community…