-
Anyone using Jira tasks in Smartsheets currently here??
Anyone using Jira tasks in Smartsheets currently here or do you know anyone ?? Please share the best practices adopted by you
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
-
Linking to other cells
Hey, So we have 2 sheets. New Projects sheet and Tasks sheet. The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually. I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it…
-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
-
Forms, Formula and fixes - Oh My!
Hello, I have created a web based form in which the user fills in certain information. As part of our metrics we need to keep track of when an quote is finished and completed. I have a date column for the quote finish and a checkbox cell for complete status. Our reports use the checkbox cell as the primary filter.…
-
wrong order of the assignments
Hello, During the last week i noticed that the order of the assignments in the sheet got wrong. Assignment number 1 became 10 (for examle). I have about 1000 assignments in this sheet it's really a big problem for me. In the beginning i tried to organize it again in the way i want to see it (and according to the row id),…
-
interaction on dasboard metric widget
Hello community, here is my problem: I have a planning on a sheet with a lot of differents actions. Some of them are complete, some others are not started or late or on hold, etc. I have also a dashboard where appears the numbers of my actions by categories with metric widgets. And now i would like to create an interaction…
-
Holidays not showing
Hi. I have loaded holidays under account settings and they are recorded on that admin screen, but they are not being reflected under new projects (in Gantt view). Any ideas?
-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…