I have a Service Years column that I would like to round in a new formula filed
This is what the formula looks like in the Service Years column
I would like to have a new field/column that take the year and month and round it up to the year.
Exampl...
I am trying to build an automation that updates a record if the status dropdown = Offer Accepted.
If Offer Accepted is selected from the dropdown, I want the automation to update a checkbox field (to no longer being checked).
Hi Alessio -
This worked, but it automatically deleted the record, instead of respecting the 14 day rule.
IF(
{Status} = “Done”,
DATETIME_DIFF(
TODAY(),
LAST_MODIFIED_TIME({Status}),
“days”
)
)
I named the above formula Column “Record Deletion Formul...
I think I don’t have the correct “Record ID”. Based on the below image, if I want to uncheck “Recruited” when status becomes “Offer Accepted” what should be my Record ID and what should be my field?
