User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a

0.5 story point = 1d,

1 story point: =2d

2 story points = 3d

3 story points = 5d


Theoretically it is possible to build a gantt chart of the N user



Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell"


The execs want a Gantt chart from my Kanban board. I will be using the Jira/SmartSheet connector for this task. Here is my current thinking:

  • Take the total number of tasks and divide by the available work time to create an average size if the tasks completely fill the time (the SME who will be


We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is