-
Advanced Calendar App - Contact List
Hello, Just wanted to get some feedback regarding changing "contact list" fields in the Advanced Calendar Application. When i am editing "contact list" fields (such as a users name) directly in the advanced Calendar App, then press the "update" button so the information is updated in the related Smartsheets, i am getting…
-
Inter Project dependencies
Hi, I have multiple projects to be managed under a program. I have a task1 under Project A which has dependency on task2 of Project B. How can I mark dependencies between two project tasks? thanks, Pragati
-
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…
