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.
IF() depending on End (and Start) being defined
IFS(AND(ISNOTBLANK([StartBreak]),ISNOTBLANK([EndBreak])),CONCATENATE([StartBreak],"-",[EndBreak]))
@Aleksi_Alkio Perfect. Thank you so much.
User | Count |
---|---|
43 | |
27 | |
24 | |
22 | |
13 |