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

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.

0 3 511
3 REPLIES 3

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

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

@Aleksi_Alkio Perfect. Thank you so much.

Top Labels in this Space