-
Link to one row - where viewers can see live updates on row
Hi, I have a large tracking sheet that I use, and would like to create links where I can share with others just one specific row with view only access, however I don't want the viewers to be able to see any other rows. I have hundreds of rows that I would like to do this for, and don't want to manually create a report for…
-
INDEX/MATCH with checkboxes and contacts
Hello, I am working on a sheet that I created that will act like a team member matrix. In the sheet I have two columns that list the name of the project and another column listing the names of who is apart of the project. The other columns in the sheet are all identifiers like (project owner, sponsor, leader, etc.) and are…
-
Cell-linking - counting values from a sheet into the cell of another sheet
Hi everyone, I'm trying to create an event summary sheet that captures data from individual event sheets to provide a live overview on where we're at with completion, health, risks, status, etc. And so I have a cell "Health" in my specific event sheet that has a number of dots (red, green, gray) depending on with the task…
-
How to get the average dates for Delta
How to get the average dates for Delta which is located in the client column: The formula I have is below: =AVERAGEIF({Hired Range 3}, {Hired Range 3} > DATE(2023, 3, 1), {Hired Range 1}) The sheet is below:
-
Auto check all check boxes in a column
Hello! I have a sheet with a check box column where end users select the check box to nominate a speaker which will trigger a separate workflow. The issue with individually selecting is that there can be upwards of 100 speakers on the list. Is there a way to have an option for the end user to click one check box or choose…
-
Calander month confusion
Good morning, Brains Trust! I'm having issues with a formula and was hoping that people smarter than me might have some answers. Objective, To find out how many lines within a cell have a date that falls within the current calendar month. Info, The cell is named "Date added" I have tried to use the formula "=COUNTIFS({Date…
-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
averageif and summary fields working inconsistently
I'm using the averageif formula in the sheet summary. it works perfectly for the first line. I've literally copied and pasted it into another field in the summary, and it's no longer working. help? I've tried under multiple names, validated the names/format by copying and pasting them, and confirmed the calculation is not…
-
Opening Item in Edit Mode VIA URL
Is there a url available to open the Edit mode? Or if I there is a way to concatenate the url using a field ID would work. I am trying to add a link to the edit mode within a column so that the user doesn't have to click on the tiny dots for edit mode.
-
Date in date column not recognized as a date
I have a formula date column that converts string date information to a date. However, Smartsheet does not recognize the result of the formula as a date. Original string example in column labeled SUG Class Date: 2023-07-11T14:00:00.000Z Formula: =LEFT(REPLACE([SUG Class Date]@row, 1, 5, ""), 2) + "/" + LEFT(REPLACE([SUG…