-
UPDATE: Is there a way to ignore case in a unique identifier
UPDATE: I figured out something about my query below - not all of the doi's on the source and target sheets have the same case (some lower case, some upper). I think this is my issue, which presents a new problem. Is there a way tell smartsheet to ignore case? Or a formula to change case? I'm running into issues where my…
-
Can't find sheets I created
I create sheets and they don't show up in my browse section. The only way I can find them is by searching for it in the tool bar. Does anyone know why that is, and any tips on how I can avoid this? It's pretty annoying and frustrating.
-
How so I get a report to sort in order of date?
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 by the Date/Time column by descending order, it doesn't work. It'll start with 1/1/24 first and work through today (3/22/24).…
-
Updating Status Based on RYGG symbols of Children Rows and RYGG Formula
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' Task Status column. I have both working but I feel like they could be cleaner and just wanted to get a second set of eyes…
-
Basic Question: How Do I Add ROWS to show in a Dashboard
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 rows add up I want that number (row total) to add up in the dashboard, as the ticket is cleared I want it removed. How do I…
-
Can you lock columns properties but allow cells are editable
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 for a work around?
-
Using an Automation to Duplicate a Row in the Same Sheet
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 the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the…
-
Printing the gantt chart
Hello, Is there a way to print ONLY the gantt chart and not the columns? Thank you!
-
Return Current Month in Cross Sheet Formula
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(MONTH(@cell), 0) = MONTH(TODAY()), [Event Date]@row, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) However, that will just return…
-
Recurring Alerts/Update Requests for an entire sheet.
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 reminders/updates to these individuals on a recurring basis. It appears the functionality for routine updates exist at a Row…
