What am I doing wrong in this IF formula?

Nickit

Nickit ✭✭

11/23/22 in Smartsheet Basics

I need the total score % reflected in the column, unless the score for Q3 is 0.

=IF(Q3 Score = 0, 0, {=SUM([Q1 Score]@row:[Q10 score]@row)})

What am I missing?

0 ·

Best Answer

Leibel S ✭✭✭✭✭✭

11/23/22 Answer ✓

@Nickit
=IF([Q3 Score]@row = 0, 0, SUM([Q1 Score]@row:[Q10 score]@row))

0 · Share on Facebook Share on Twitter

Answers

Leibel S ✭✭✭✭✭✭

11/23/22 Answer ✓

@Nickit
=IF([Q3 Score]@row = 0, 0, SUM([Q1 Score]@row:[Q10 score]@row))

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

how to get automated workflow to trigger when a new row is added from a form?
I've created the automation below and would like it to run whenever a new row is added from a form. I've tested it out and when i create a new row the automation doesn't trigger- where am I going wrong?
Restore previous version
Hi all - a poorly structured data shuttle update has deleted all my sheet data. I'm on hold to support but does anyone know how to restore a previous version of a sheet?
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…

Help shape the future of Smartsheet.
Share your ideas and feature requests.