-
Demo of Business to show managers
Hello, I am trying to explore the resources project planning section. I had a personal for months, but would like to explore the business level. Is there a way to demo the business software? regards, Tom
-
Dynamic View & Alerts and Actions
I have set up Alerts and Actions in my source sheet, but I have not shared the source sheet with process partners - instead, they have a Dynamic View I'd like them to look at instead. Can Rules and Alerts apply to people who are not shared with the source data? I keep receiving emails about Invalid Recipients and I'm not…
-
Survey for each client project (multiple forms one sheet)
I have a set of surveys which we have been sent out through smartsheet, each on their own sheet. At the end of the year, I am required to export all results and consolidate them for a year overall report. To help streamline this I have created multiple forms in one sheet for this year. What I need is to be able to label…
-
Resource View / Completed Projects
If a task/project assigned to a person has been checked off as 100% complete before the assigned deadline, is there a way for the Resource View to update in order to show that person being available during that time, without going to the sheet and updating the duration/end date of the task? This way that person could be…
-
Any Potential for Linking Reports to Sheets?
Hello, I wish there was a way to link a report to a sheet - does anyone know how to do this, or is it possible? I am hitting my link capacities for our production reporting, but what I really wish I could do is to sum a qty in a report and then graph it on a dashboard. Is there anything in the works at Smartsheets…
-
how to define who the approval is from multiples
I have migrated our Engineering change to smartsheets which is working fine. I now want to progress this by adding approval requests. We can get changes approved by 3 different people, so I have created an approval request which gets sent out once a box is checked to declare the change is ready for approval. At present…
-
New User Help - formulas and ranges
Hi, I'll try to describe in detail what I want to do and would appreciate any help you can provide. I have a range of cells that show Red,Yellow or Green Balls and this is used to check the status of each stage in a project. I would like to also have a cell at the top level of the project that displays RED if there are any…
-
Calculate Total Number of Dates within a Month per Department
Hello, I am a total newbie with SmartSheet and on the struggle bus with this calculation quest. Here is what I am trying to do: I have a sheet entitled 'ES Monitoring' that each department needs to fill in at least daily to track safety behaviors within their department. The columns in this sheet that I want to summarize…
-
21 CFR Part 11 compliance and software validation usage in Design Control
I would like to request if there are MED device users to share their experience while working on medical device or pharma projects that are related to new product initiative filings requiring regulatory complaince in closed loop systems integration and security. Have you had to prove part 11 and validation compliance? Your…
-
Formula Help
Hello, Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic. I have a metrics sheet that I am using to provide data from other sheets to populate a dashboard. I currently have this formula and similar formulas that pull data within a…