Help

Updating dates that are coming from different sources

123 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Samantha_Joppe-
4 - Data Explorer
4 - Data Explorer

Hi, 

I have two dates in my base, one is manually inputted, the second is linked from another tab. The date pulled from another tab is the most recent date and we need this date to replace the manually inputted date so we can track most recent updates. 
I've tried creating a new column that merges these dates but that isn't working. I don't know what I am missing.
I attached that it looks like not sure if anyone can help. 

Thanks in advance for reading this!

Sam

2 Replies 2
Brian_Sweeny
6 - Interface Innovator
6 - Interface Innovator

Hi there! Sounds like you need a simple automation, not another field. Every time the 'updated date' changes, it copies and pastes this date into the manually inputted (Last Update) field. I do get the sense, however that your base may not be structured properly. Feel free to schedule a session with me if you need more help!

Does this look right to you?
Screenshot 2024-05-14 at 11.31.24 PM.png

IF(
  {Date (from New table)},
  {Date (from New table)},
  Date
)


Link to base