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.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |