I am trying to populate a cell based on the State that they had choice from a dropdown column on the same sheet/row. I am tried many variations of the below formula and it is not working.
Does anyone have any suggestions.
This looks correct to me - there is a stray space after the second IF statement before the bracket. That might help
I did try the CONTAINS formula and it worked with the exception of Arkansas/Kansas, etc.
I switched it to a HAS formula and it worked perfectly.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello Requesting a formula (column) to return a date to a specific week but is always on a Tuesday. My spreadsheet is a work back schedule to a specific date. Launch date occurs on any day of the week but I need minus 3 weeks to land on Tuesdays. Thank you
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…
©2024. All Rights Reserved Smartsheet Inc.