How to find & replace a specific selection in a multiple select field without changing the other selections at a specific time

Use a formula field like this

IF(
DATETIME_FORMAT(NOW(), "dd HH") = "Mo 06",
SUBSTITUTE({Content Status}, "Followed up on content", "Need to follow up")
)

Set ann automation to trigger when that Formula field is not empty. Then add a Update Record action step that inserts the formula result into the {Content Status} field.

If you have several hundred records that need to be updated, a script would be more efficient. Also the button-activation would probably work best as a (slightly different) script

IF(
DATETIME_FORMAT(NOW(), "dd HH") = "Mo 06",
SUBSTITUTE({Content Status}, "Followed up on content", "Need to follow up")
)

@Kamille_Parks11this is helpful - I am trying to do something similar and would love to see how you would set-up the automation! 

I am basically trying FIND any record that has both "No RTW Feedback" & "RTW Received" in the multiselect (called Feedback Status) and REPLACE "No RTW Feedback" with "RTW Received" all while keeping the other multiselect inputs that same (in this case, "No PL Feedback".

For context - the "No RTW Feedback" status gets added via an automation after we have completed reaching out to a user for feedback and they don't provide any feedback. 

And the "RTW Received" status gets added via an automation whenever feedback is submitted.

The trouble is - in instances where a user gives us feedback AFTER we finish reaching out to them, we end up with two statuses ("No RTW Feedback" & "RTW Received"). 

Ideal state is if when feedback is received, the "No RTW Feedback" is REPLACED by "RTW Received" (without over-riding the PL status).

Do you have any suggestions? 

@Kamille_Parks11 I actually figured this out! I worked out a solution using an IF + CONCATENATE formula + an automation. 

Thanks for the inspo here!