I have a virtual column with the formula '=CO...

(Simon Blackburn) #1

I have a virtual column with the formula ‘=CONCATENATE(TEXT([Start Break]),"-",TEXT([End Break]))’.

If a particular shift doesnt have a break, the break column still displays in the app with ‘-’ as the only data.

Is there a way i can still use a hyphen in the concat for when a shift DOES have a break but not display anything if [Start Break] and [End Break] are empty?

I have attached a screenshot of the detail view showing the break column.

(Simon Masters) #2

IF() depending on End (and Start) being defined

(Aleksi Alkio) #3

IFS(AND(ISNOTBLANK([StartBreak]),ISNOTBLANK([EndBreak])),CONCATENATE([StartBreak],"-",[EndBreak]))

(Simon Blackburn) #4

@Aleksi_Alkio Perfect. Thank you so much.