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 |
---|---|
63 | |
25 | |
14 | |
11 | |
6 |