Problems with Formula

I have to write a formula that enters in the column called ‘Job Closing Time’ how many days have passed between the date of the ‘Start’ column and the date of the ‘End’ column, only if the Status column is Closed.
I tried with this: if{Status} = “Closed” dateDif {End} - {Start} , but it doesnt’work. Help me please.

Please consult the formula reference: Formula Reference - SeaTable

You have to pay attention to the syntax required by the formula (e.g., brackets, commas, units). This should work:

if({Status} = “Closed”, dateDif({Start}, {End}, “D”))

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.