-
Meeting Minutes In Project Plan
Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank meeting minutes form for a call, complete that form, and archive those minutes still in that specific subsection of the…
-
Auto Assigning Values In Smartsheet
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I would like for the value of percent completed to auto-fill to 0 Whenever a new task is made, and leave it up to the employee…
-
How to return only the most recent entry before a targeted date range?
Hello, I currently have the following asset booking sheet: What I'm trying to do is, for the column 'Assignee in Possession Before Your Booking Date:', if the asset is available within the booking date range that the user has entered -- I would like the column to display what assignee will have the asset last (most…
-
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…
