-
With COUNTM I can determine multiple selections are made, how can I extract the specifc selections?
If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or CONTAINS and looking for names one at time?
-
Updating Existing Row from Form Data
Hi - I have a request to create a sheet where a team member wants to input data, and then send a form link out for additional information to be collected. We would all of this information to be populated on one line Does anyone know if this is possible, and if so, how to do it? Thank you! Sheryl Sheldon Cincinnati…
-
Referencing a cell on another sheet based on information in its' parent
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with…
-
Is there a way to customize the submission confirmation page?
I have built an audit for the operations folks to fill out and submit via Forms. They are wanting to have their score automatically appear on the submission confirmation page so a few questions: Is that possible? If it is possible, how do I build that feature in and what sheets, formulas, etc. are required?
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
-
Does anyone have experience geocoding addresses within Smartsheet?
We are looking to geocode street addresses that are entered into Smartsheet.
-
Help with RYG Balls - Looking for an Average
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with…
-
Red Flag for overdue tasks
Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red flags every row that doesn't have a date in yes which is an issue as we are using a project…
-
Why are my Parent rows constantly expanding when the Filter is turned on?
Hello, All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page. Is there a way to have my filter on and keep the Parents rows from expanding automatically?
