I have a formula that takes a datefield and formats it the same way as my Primary Field, in my link table called Room Moved for Copy,.
I have automation I want to run that will watch the Date Field for any time it updates and then I want to take the new result in Room Moved for Copy and paste it into my Time Slots Linked Field.
I am getting an error. I suspect it is because the result is not a sting but not sure.
DATETIME_FORMAT({Meeting Start}, “MM/DD/YYYY HH:mm”)
Any help getting this to work would be amazing!