Troubleshooting HubSpot Table Enrichment Date Formula Issues
Hey there! I'm about done creating an evergreen table that will enrich companies whenever their last enrichment date was over 6 months ago. I want to map a last enrichment date into hubspot of when that specific company is added to the table and any of 5 enrichments were updated, but having trouble creating the formula. So far I've tried: moment().format('MM-DD-YYYY')
but i want it to only update if one of the 5 key enrichments im mapping into HS are updated
{{Operational Status - Enrichment}}?.response || {{Check if URL is Valid}}?.valid || {{Event Industry Classification - Enrichment}}?.response || {{Instagram Profile URL (FINAL)}} || {{Instagram Follower Count (FINAL)}} ? moment().format('MM-DD-YYYY') : ""
this doesnt seem to be returning accurate results - all of the rows are returning yesterdays date even though i just updated the table to add the last row a few minutes ago
here's the table: https://app.clay.com/workspaces/338374/workbooks/wb_FzjKYZcMw4cR/tables/t_jP49hWCHtsT7/views/gv_qq5SusMwJ7wA