why does this formula =AVG([Onsite Duration]:[Onsite Duration]) return #DIVIDE BY ZERO

Weston Johnson

Weston Johnson ✭✭

10/27/23 in Formulas and Functions

0 ·

Answers

Eric Law ✭✭✭✭✭✭

10/27/23

@Weston Johnson It most likely means you have no info in that column, hence zero.

0 · Share on Facebook Share on Twitter
Weston Johnson ✭✭

10/27/23

I do have data in the cells maybe there is a fault with that data thanks for your help.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

how to collect a date within a sheet?
Hi, in the image below I have in my "extrusion" column an entry that populates by a formula (in this case "M3406 HEAD TRACK 15' is populating) I'm looking to populate the "Last Cycle Count Date" column by searching the "last cycle count date" from rows 1:49 looking for a date that has the "extrusion column from rows 1:49…
Networkdays formula between today and go live date
Hi, I would like a formula to calculate the number of network days between todays date and a go live date and return a negative if go live is in past and positive if go live is in future eg todays date 24/03/25, (go live date) 29/03/25 = 5 days Here is the formula im currently using =TODAY() - [Requested Go-Live]@row on my…
Countifs witth contains referencing another sheet
Hi all, I cannot seem to find the issue with my formula. It gives me the error #incorrect argument set. Can someone help me? I suspect it to be the last part with the contains. =COUNTIFS({5. EMEA - Belgium - Error Log month}, {5. EMEA - Belgium - Error Log month} = Month@row, {5. EMEA - Belgium - Error Log To be fixed by},…