-
Report connecting multiple sheets
I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status. How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.
-
Row sharing work around suggestions?
I am a new user of smart sheet. I have recently just set-up smartsheet as a tool to track around 200 customer work requests that are going through a University manufacturing workshop. The nature of the work means that there needs to be a reasonable amount of exchange of information between the technicians doing the…
-
Linked Cells and Indentation
I'm pretty new to Smartsheet so please forgive any ignorance I may have. I have a program with three providers managing their portion of the program. I want to have each provider maintain their own schedule in their own sheet and have a master sheet that includes all the tasks that I'm managing as well as links to all the…
-
Changed Duration Time for Report
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
-
Automated Approval Requests
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
-
Date fields not working on Live Data Link API
This is day two of the date fields coming into our excel sheet as 01/01/1900 and it causing problems with our scheduling needs. What is the ETA of this getting resolved?
-
Want to track resource allocation
Has anyone had any luck with this? Want to do something similar to the features in Microsoft Project. I have a lot of design projects going on and want to be able to allocate resources (my designers) to projects and be alerted to when a resource is exhausted. Has anyone been able to figure this out? I would really…
-
Risk Level Formula
Hello, I am trying to calculate risk level automatically (by displaying RYG balls) based on the following: Risk Level is Green If I get one of the following combinations: * Impact = Low AND Probability = Not Likely * Impact = Low AND Probability = Likely * Impact = Med AND Probability = Not Likely Risk Level is Yellow If I…
-
Simple way for creating dashboard on issue log
So I am logging issues on a sheet and there is a column showing the respective status (i.e. Open, WIP, Closed, etc.) for each of them. I m in search of a simple way to create a dashboard to show the no. of issues under each status on the same sheet.
