-
Auto drag down TODAY formula
Hello! I have a sheet with a column designated to always show the =TODAY(0) formula. However, I noticed that when new rows are added, I have to manually drag down the formula. Is there a way to auto-populate the column and lock it so each new row will always have this formula? Thanks!
-
VLOOKUP resulting in some references coming back as #NO MATCH.
I have a master Smartsheet people fill-out a form for that submits purchase orders made. I have a corresponding Smartsheet that people fill-out a form for to indicate when a specific PO has been received. In the master Smartsheet I am attempting to use a VLOOKUP that looks at the PO number from the master Smartsheet andโฆ
-
Minimizing Data in Email
Hello, I have created a leave request form for my organization. I have created a Automation in the leave request form. But when someone submit the form their respective supervisor and HR gets the notification with all the fields as per the main sheet. I would like to minimize it and only send the relevant data for theโฆ
-
Logic
Hi, I have created a form for leave request for my office. I would like to add a logic (or any other way) that "if the start date and end date are same" than a new field with the option to select a "full day leave or half day leave" appears. If suggest if its possible or any other alternative to do so. thanks in advance.
-
VLOOKUP to Return Two Users
Hi! I need a formula that looks at two columns and returns an email address based on vlookup if one of the two columns is blank and two email addresses (again based on vlookup) if neither column is blank. The formula works well when one of the columns is blank and only one email address is returned. The problem is when twoโฆ
-
Auto filtering to another sheet
I have a grid sheet with a form for a training sign off(UTV). I'd like to take the date "Date" and name "Name" of the person who filled out the form and move/copy just these two columns to a new sheet. The new sheet has columns that are different than the previous sheet, in that the date I moved from the UTV sign offโฆ
-
Formula for [date]+1 month?
Hi all, If I was using excel, I'd use: '=DATE(YEAR($A1),MONTH($A1)+1,DAY($A1)) However the equivalent smartsheet formula... '=DATE(YEAR([Column2]12), MONTH([Column2]12) + 1, DAY([Column2]12)) ...doesn't seem to be very "smart" at all, because it gets to December and can't handle the concept of rolling over into the nextโฆ
-
IF/AND Formula with Dates
Hi all, I am trying to create a formula that will apply an X to a cell if the selected Date is between two other Dates (ie. Check In and Check Out dates). Currently I have a formula similar to what you would use in Excel: =IF(AND([TUESDAY 4/20]17 >= [CHECK-IN]@row, [TUESDAY 4/20]17 <= [CHECK-OUT]@row), "X") Check In andโฆ
-
Cannot use negative lag time in dependency
When i try to use a negative number eg. -10d in the field "lag" to create a lead in dependencies I get an error "Invalid lag duration". Am I misunderstanding the help or is it not possible? thanks in advance. Edit: manual input in column did work ๐, only not via the editor.
-
Days Open if Task Status is Closed
I am new to Smartsheets and I am trying to show how long a task has been open since the project Start Date, but, if the task is marked as "closed", I want the "Days Open" column to record the Date Completed minus Start date, but if task is still Open or In progress, I want the "Days Open" column to record the number ofโฆ