-
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…
-
#Invalid Ref
I'm trying to reference another sheet and get a count of items that meet multiple criteria. My formula syntax is =COUNTIFS({173000 High School UUU Model Review Items Range 1}, "3-Critical", {Phase}, "CD") Do I need the function HAS? When I've tried inserting HAS, I get UNPARSEABLE. With the syntax I have now, I get…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
