MID Function

Returns a portion of text based on a given starting point and number of characters
Sample Usage
MID("Hello World!", 2, 5)
  • text
  • start_position
  • num_chars
  • text
    The text that you want to return a portion from
  • start_position
    Starting from the left, the number of the character you want to return
  • num_chars
    Starting from the left and depending on the start_position, the total number of characters to extract

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community