I have a list of birthdates, formatted as 01/01/2001. What formula can I use to pull just 01/01 to another cell?
Hi @Linda Hwang,
One way of achieving this is using the LEFT function, which returns the leftmost characters from a text string. More info here: https://help.smartsheet.com/function/left
If you want to return DD/MM in a new column, the formula would look like:
=LEFT([name of your birthdates column]@row, 5)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I am hoping someone might be able to guide me. I am trying to count how many of certain courses people are interested in. All options populate into the same column. Is there a way to do something like: =COUNTIF(Which courses are you interested in?, Project Management)
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column I am trying to create a summary sheet to count the number assigned I have tried both Contains & HAS But my answer is 0 - Just using the count if gets me 23 and there are 2…
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
©2024. All Rights Reserved Smartsheet Inc.