This may just be a vent, but I have a report that pulls from about 15 different sheets with archived data from 2024 and 2023. I want the most recent submissions to show first. When I sort the report b…
New day, new formula conundrums! For these formulas, I'm looking to update the status of my PARENT rows (2 levels) based on the RYGG symbol as well as having the RYGG symbol is based the CHILDREN rows…
I feel dumb, but I can't figure out how to add up the total rows and get them to appear as a metric in a Dashboard. It's a complaint ticketing system, as a new complaint comes in it adds a row. As the…
I'm making something for internal customers. I want them to be able to change the cell values in the column, but not the column title and properties. Is this possible? If not, does anyone have an idea…
I have read several posts that suggests that this is not currently an option. I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of t…
Hi all, I need to pull counts of events related to account #'s for the current month. On the raw data sheet, I have the row calculation working with this formula: =COUNTIFS([Event Date]@row, IFERROR(M…
Hi, I have noticed that the criteria for sending update requests to an individual in a 'contacts' column can be set for a specific date, but I am looking for the ability to send a routine monthly remi…
Hi Smartsheet Community! Issue we are trying to resolve: We have an intake request form that provides the client with an opportunity to request a preferred start and end date range or fill in with "AS…
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under spec…