Empty column returns invalid parameter in Formula

Platform discussions Special workflows & use cases
1

Hey,

I’ve got 3 text columns and a formula column.
The formula should just add up the 3 columns and display them as hours and minutes - which it does sucessfully, however if one or the columns are empty then I get the red circle saying “Invalid parameter in Formula”.

I’ve attempted to add code which would set it to 0 rather than empty but thats still not working.

Any ideas?

IF(OR(({Copy Scheduled Hrs}+"0") <> 0,({Design Scheduled Hrs}+"0") <> 0,({Mgnt Scheduled Hrs}+"0") <> 0), TEXT(ROUNDDOWN(({Mgnt Scheduled Hrs}+{Design Scheduled Hrs}+{Copy Scheduled Hrs})/60,0),"#0") & "h " & TEXT(ROUNDDOWN(MOD(({Mgnt Scheduled Hrs}+{Design Scheduled Hrs}+{Copy Scheduled Hrs}),60),0),"00") & "m","00:00")

I have tried:
({Copy Scheduled Hrs} + 0)
({Copy Scheduled Hrs} + "")
and ({Copy Scheduled Hrs} + "0")

but nothing works.

2

@johnners

Try:
("0" & {Copy Scheduled Hrs} + 0)

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Creating subitems using Make/Integromat The Monday Man (EASY) Way
Contact me directly here: Contact – The Monday Man