-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…
-
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?