Update Status Field Across Multiple Tables for Spe...

[SadieYanckello]

Is there a way to set up an automation so that the current date is recorded when a specific status is met. For example, When a project's "status" is changed from incomplete to complete, a date column would automatically fill with that day's date?

[Christian_Sabou]

You could run a script

const now = new Date();
let inputConfig=input.config();
let CellId=inputConfig.StatusChanged;
let table = base.getTable("All Projects");
await table.updateRecordAsync(CellId, {
    "Completion Date": now
})