-
Error when running out of CPU memory
Not really a question but more of a heads up. I had a sheet with almost the max rows and 6 columns and 2 references. Tried to add a column formula and my CPU ran out of memory. After the browser crashed I went back to the sheet and smartsheet threw the exceeds 2.5 Million cell reference error. Im no where near 2.5 million.…
-
Changing a cell's values from code in a different cell
Is it possible to change the value of a certain cell using code in another cell. I would imagine it looking similar to this format.. IF(column@row=X, different_cell=XX, different_cell=XXX)
-
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…