Forum Discussion

ChloeZ's avatar
ChloeZ
Copper Contributor
Nov 08, 2023

Column Format (Include the Date in a cell and automatically include it in a "Concatenate" cell)

I am trying to get a formula that would combine texts and dates and display into a cell from a Microsoft Teams List.

 

(txt)              (date)         (txt)                  (choice)      (txt)

name           Date           completed       Task Sites   Combined list

Billy10/20/2023clean- ABilly 10/20/23 clean -A  
Billy10/22/2023clean- B 
Billy10/22/2023clean- C 
Billy10/22/2023clean- D      

 

 

the closest I've gotten is:

=CONCATENATE("Billy ",+"[$Date]",+"clean",+"[$Task Sites]")

 

however, after submitting a new list (form) the output is: Billy [$Date] clean [$Task Sites]

 

name           Date           completed       Task Sites   Combined list

Billy10/20/2023clean- ABilly [$Date] clean [$Task Sites]         



No RepliesBe the first to reply

Resources