-
Export to Database
Hi, I wish to store the data on my smartsheet to a local SQL database. How do I go about doing this? We need this to create metrics that can track time taken for approvals etc.
-
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…
