Can I add a formula to a field that activates as they use the form. Such as a vlookup that has the name of a supervisor and then looks up (vlookup) to pre-populates the contact info (email and phone) from a smartsheets form.
Hey @Cheryl Hishmeh
Forms can't contain formulas. You can however have columns in the sheet that are column formulas that contain the VLOOKUP. So once the information is entered the VLOOKUP is inserted into the row automatically. Assuming all the supervisors are listed in a sheet somewhere this would work.
If on occasion that information needs to be entered you can use logic in the form to have a dropdown that lists all the supervisors and if they select Other it gives them two more options to fill out and than have the VLOOKUP column start with an IF statement looking to see if those two entered information columns are blank or not.
Tip: Create column formulas by right-clicking on the formula in a cell and selecting "Convert to Column Formula"
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello, I am using a formula to extract a date from a string of text. It appears to be working, but if I leave the sheet and come back later it continually reformats the date from MM/DD/YY to YYYY,MM,DD. The target columns are formatted as dates, and the original column is a dropdown list. I can change the target column…
I have a sheet with a resource count than can be blank or contain from 1- 5. For each resource count there is a corresponding work effort in the next column, separated by a comma (see table below). I am trying to extract the work effort totals into separate cells WE1 through WE5. Objective: Using formulas found in the SS…
Hello there, I'm new in SS. I'm trying to create a formula for the status column. I have the following status: On track At Risk Late Not Started =IF([Start Date]1 > TODAY(), "Not Started", IF([End Date]1 > TODAY(), "On Track", IF([End Date]1 = TODAY(), "At Risk", IF(AND([% Complete]1 = 1, [End Date]1 < TODAY()),…
©2024. All Rights Reserved Smartsheet Inc.