-
Report Layout with Multi-Select Dropdown Column
I am asking for assistance on a report layout. We have 15 Regions. Each Region has small teams. I have some team members that are on several teams. We have a column called “Region” that is a multi-select dropdown column. We like the report that outlines every region’s team members. The report is sorted by region first and…
-
How do you exclude a specific status from another sheet in a formula?
Hello! I'm having trouble finding a way to exclude a status from this formula: =IF([Total on PTO]@row < 2, "Under Limit", IF([Total on PTO]@row = 2, "At Limit", "Over Limit")) It's referencing another sheet for PTO requests. The limit is including requests that have been withdrawn, but we don't count those as the actual…
-
Chart not showing all data when sheet is sorted
Hello, I am encountering an issuing when trying to sort the information in my sheet that is being displayed in a chart. When I sort on the columns that contains a metric that I am displaying it reduces the amount of data being shown. The first set of images is displaying all of the information I want and the sheet is…
-
Unable to share sheet to the owner of the sheet using share api.
On calling the following api, getting the "SUCCESS" message but sheet is not shared to the owner. Is there any way so that the sheet can also be shared with owner through an email?
-
Show my "up next date" based on the child-parent task relationship?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and grabs the one closest to today's date so I know the "next upcoming due date" among a parent's children/sub-tasks. What…
-
How can I make a column only show me the last 4 digits of each cell within a column.
For instance, how can I make the column only show me the last 4 digits within the column itself. So that we can enter the last 6 digits via a Form, but it only shows the last 4 digits within the sheet.
-
Preserving Approval Date
I heard in an ENGAGE 2018 video on alerts is that you can set an alert to request approval based on the values of one of the cells in the row. You can choose a column with drop-down properties to indicate that the alert was Submitted, Declined or Approved. Someone at the session asked if there is a way to know the date of…
-
Formatting A Sheet
Hi all! I am back again with another Smartsheet question! This time I'm not certain if what I'm asking for is even possible. I was wondering if it would be possible to format 3 columns to make them smaller and more digestible. At the moment, I have a sheet that displays dates tasks have been completed, the week of that…
-
How to include a cell value name in my automation list
To setup automation, the trigger part works perfectly fine. However, the response is to change the cell value, but the cell name doesn't appear in any of the options.
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?