Why isn't this simple formula working?

Options

Hi, I am trying to add 3 columns together in one column. Each of the three columns below are populated by other formulas.

All of the formulas below return an #UNPARSEABLE error

=COUNT([# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

=SUM([# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

=[# OF DETECTNET REQUESTS OPEN (AWAITING DECISION)]@row + [# OF DETECTNET REQUESTS PENDING (CREDIT APPROVED)]@row + [# OF DETECTNET REQUESTS PENDING (CAH TO PROCESS)

Any suggestions would be appreciated.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!