Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Summing WORKDAY_DIFF numeric outputs

Topic Labels: Formulas
Solved
Jump to Solution
295 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi All - This will be my first post. I would like for our category row ‘Summary’ cell to sum the output of our number of work days driven by the following formula

IF({Start Date} = BLANK(), “0”, WORKDAY_DIFF({Start Date}, {Finish Date}))

The formula currently is working to output the numeric value of the number or work days, but AirTable ‘Summary’ does not recognize it as numeric and thus does offer the option to sum the results into the Summary cell.

HoMkYOsxia

1 Solution

Accepted Solutions

Your output isn’t a number because you put quotes around the zero. Remove the quotes and you should be fine. 0 is a number, "0" is a string.

See Solution in Thread

2 Replies 2

Your output isn’t a number because you put quotes around the zero. Remove the quotes and you should be fine. 0 is a number, "0" is a string.

And like that it’s magic @Kamille_Parks. Thank you! What a fundamentally applicable lesson. If it helps me understand even the tip of the iceberg of coding I’m happy. Appreciate the direction.