-
Traffic lights count by colour if children
Hi there, I'm trying to count the number of projects according to their traffic light status across about 7 sheets. Given I want to display this in Sights as a Metric, I can't use a report so I have a sheet linking to the summary information from each sheet. When I use the Countif formula to count those that are "Red" it…
-
Send Update Request - Button not Hyperlinked in JIRA ticket
Hi All, I use Send update request to email alias that automatically creates a JIRA ticket. However the Open Update Form Button - is not linked in the JIRA ticket description ? Any ideas how I can get the Update Form button to open ?
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
-
Master sheet overview
Hi I am currently working in a team where many projects (not necessarily related) are running alongside each other. We would like to create a smart sheet master template/dashboard that allows the project manager to manage his/her own smart sheet for the given project themselves, while all the data from the particular…
-
Need Guidance - Can you develop a Generic Project Schedule in Smartsheet
Can you create a generic project schedule in Smartsheet? For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and ends Day 90 (end of month 3), Task 3 starts Day 31 (start month 2) and ends Day 180 (end month 6), etc. In Gannt View, you…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Report Builder - Not Sorting Dates
Hello - I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
pallet configurations in smartsheet
Does anyone have a way to figure out pallet configurations in smartsheet given the case specs?
-
Skype for Business - having issues with joining people in conversations
Skype for business has all been set up for us and I can see who is online, however when I try to open up a chat withsomeone it always shows the message, once I have typed in that they cannot join the conversation and they disappear in the window. Is this normal? Is this a Smartsheet thing or an IT department kind of thing?