Forum Discussion
ChloeZ
Nov 08, 2023Copper Contributor
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
Billy | 10/20/2023 | clean | - A | Billy 10/20/23 clean -A |
Billy | 10/22/2023 | clean | - B | |
Billy | 10/22/2023 | clean | - C | |
Billy | 10/22/2023 | clean | - 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
Billy | 10/20/2023 | clean | - A | Billy [$Date] clean [$Task Sites] |
No RepliesBe the first to reply