-
Smartsheets as replacement for jira _ software dev
Hi Everyone Question: Are there any plans to enable smartsheets to be used within a multi functional software dev team?, Specifically, allowing rich stories/cards (multi media, a good amount of text, flexible formatting, easy creation/adaption)? Smartsheets seems to work great for task management / planning but doesn't…
-
Nested Index/Match if Partial Text
I require a cross-sheet formula that will search for a Task (row) in another smartsheet, if the Task ‘Comment’ (column) contains the word “All”, then go to another Task row and index the Date. If the Task ‘Comment’ (column) does not include the word “All”, display the original Task Date. For example: If Task 4 Comment…
-
New Products sheet with many fields that need updates
I am looking to create an automation to ask resources responsible for specific data points in a smartsheet of new fabric data. I have listed the new product in 216 rows with 55 columns. Specific people are responsible to provide data in each of the cells in each row. I want to create a reminder to have them get that data…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Sheet Summary Report Builder only shows the system columns
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge together data from columns other than the system columns. Am I doing something wrong?
-
Effort Vs Duration
Hi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime within a 5 week time spell - how would I show this on the plan so that the resource…
-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Secondary Axis in the Graph
Hello All, I'm trying to create a two axis graph like primary and secondary axis but unable to change the elements to secondary axis (See the screenshot, I wanted to show the cumulative in the secondary axis, can anyone help me out.
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…