I have an excel spreadsheet with many calculations. Given my current understanding of formulas, it is very much like excel so my question is below.
Formula in Excel
=IF(SUM(N22:Q23)<>0,SUM(N22:Q23),"")
Field names in Airtable
N22= シャトル台数(Shuttle Qty)
Q23= 予備シャトル台数(Sp. Shuttle Qty)
So my airtable formula should be as follows
IF(SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数(Sp. Shuttle Qty)}<>0,SUM({シャトル台数(Shuttle Qty)}:{予備シャトル台数(Sp. Shuttle Qty)}),"")
But I keep getting an error. Where are my assumptions wrong? It is simple addition problem
Order Qty - Shuttle |
Shuttle Qty | 28 |
Spare Shuttle Qty | 2 |
Total Shuttle Qty | 30 |