Problems with Formula

User Talk Formulas
1

Hi,
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.

2

Please consult the formula reference: Formula Reference - SeaTable

3

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
4

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