-
Modified =SUM(CHILDREN()) Formula needed
Dear All, I am struggling to modify this formula: =SUM(CHILDREN(Points@row)) Working in agile development, my "Points" column contains development points needed to complete a task. Overall I have 4 hierarchy levels: Task, User Story, Epic, Initiative. I would like to display the sum of task points on the User Story line…
-
Max Formula - related question
Hi I have a table for our Product Development Items. In it I track 3 levels of items: Initiative, Epic, User Story. In a separate column I assign Quarters, e.g. Q1'23, Q2'23, or H1'24 or 2025. For the Parent level I would love to be able to identify which of those is the farthest out quarter. Is this possible? Best, Sylvia…
-
Can I auto-populate a value from the parent row to the children row?
Hi I am building a product planning tool. I will have Initiatives, Epics, and User Stories, each will have a identifier Initiative: e.g. I-123, Epic: e.g. E-123, User Story: e.g. US-123. I would like to create two columns, column 1: auto-populates the Initiative number to all Epics and User Stories below it column 2:…
-
Multiple Sheets
Hi All, I have created multiple sheets and assigned different individuals to carry out their tasks in their own sheet. While I have set up the automation separately in the back of each sheet to move rows once certain criteria are met and move the sheet (Job) on to its next stage and next employee. I would like my original…
-
Using IF AND & OR in the same function
I've seen a couple questions involving AND and ORs separately but nothing involving them together with IF. I'm trying to get a checkbox to automatically check if the following criteria match: Self Survey Column is green Workshop Attended Column is checked off Evaluations Column is either "completed" or 5 or above. The…
-
Date Column Not Working
When I enter dates into the column titled "Start Date" or "End Date", the data disappears from the cell.
-
Expandable/Collapsible Columns with buttons (not hiding)?
Is there any capability in Smartsheets similar to this excel screenshot where columns are able to be expanded and collapsed in a grouping using a button? The scenario at hand is supplier contact information being tacked on in several columns at the end of a sheet and it isn't information used on a regular basis but needs…
-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
-
Free User - Switch which sheets are editable
Hi folks, New user here, and loving Smartsheet for the most part. My free trial just ended and I had a bunch of sheets created. I knew I would only have access to two (editable) once the trial ended. Does anyone know if you can switch which sheets are editable? I accidentally made one editable when I shouldn't have, and…
-
What Formula to use to Count the number of Unique Dropdown Phrase Utilized
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list. For example, I am having a hard time counting how many…
