Why can't I compute a simple division formula?

SmartsheetUser99

SmartsheetUser99 ✭✭

05/22/24 in Formulas and Functions

I am trying to divide one cell by another cell using the below to formulas. I am getting a #invalid operation.

=COUNTIF(Complete1:Complete12, 1) + ""

=(Complete14 / 12)

Tags:

Formulas

0 ·

Answers

Protonsponge Community Champion

05/22/24 edited 05/22/24

=COUNTIF(complete:complete, 1)
=complete14/12
The Smartsheet formula hand book can be a great resource to learn about all formula and operators:- https://app.smartsheet.com/b/publish?EQBCT=32f8257f5d1948bfa948da170231a0c5&_gl=1*1mtrm33*_ga*MTExNzQ4MDA2My4xNjkyMjc5MzQ1*_ga_ZYH7XNXMZK*MTcxNjM5MjAxNi4yLjEuMTcxNjM5Mzc4Ny41MS4wLjA.*_gcl_au*MTk3NzI3NTA2Mi4xNzE2MzkyMDE2&_ga=2.36833760.1789047969.1716154465-1117480063.1692279345

0 · Share on Facebook Share on Twitter
Protonsponge Community Champion

05/22/24

0 · Share on Facebook Share on Twitter
SmartsheetUser99 ✭✭

05/22/24

Perfect. Thanks

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

Collect an column entry when data is entered by a form
Hi, I'm still tearing my hair out over this issue, and I'm hoping someone can help me. In our set up that is run through control centre, we have specific information that is entered onto a sheet via a form. I need to link the information that is entered into that form back to the metadata for each project. The issue I'm…
Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…