Returns a portion of text based on a given starting point and number of characters
Sample Usage
MID("Hello World!", 2, 5)
Syntax
MID(
-
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
Examples
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.