-
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…
-
Mark Duplicate value
Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
INDEX MATCH Multiple criteria
Hello, I am trying to get the zip code based on city and state from a different sheet. The sheet that I want to return information from has 3 columns: City, State, Zip code. There are 20,000 rows in the sheet that I am trying to use as a reference with all the cities in the United States The sheet that I want to write the…
-
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…
-
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?
-
Forms that need to incorporate multiple line entries
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is filled in and the 'save' button pressed Are we able to set up a Smartsheet form to…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
ISBLANK combined with AND statements
Hi, I'm having trouble nesting AND & OR statements with the ISBLANK condition in my IF statement. I have two columns: [Agreed End Date] and [Actual End Date] =IF(AND(NOT(ISBLANK([Actual End Date])), (OR(TODAY() - [Agreed End Date]@row < 1, "On Track", IF(TODAY() - [Agreed End Date]@row < 7, "Delay", IF(TODAY() - [Agreed…
-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…