Skip to content

Please Help with Summit Formula

David Metzler

David Metzler ✭✭

01/25/19 edited 12/09/19 in Smartsheet Basics

I want to if assigned person is correct to then take information from one cell and transfer to a different cell automatically?

This is the formula I have so far however when I enter this it gives the #unparseable error

=SUMIF([Fielder Assigned]:[Fielder Assigned],"Name",[Rural Mileage]:[Rural Mileage)

Tags:

Cell linking

0 ·

Comments

David Hersher ✭✭

01/25/19

Hi David,

I think you're just missing the close bracket on the last RURAL MILEAGE reference.

Dave

0 · Share on Facebook Share on Twitter
Mike Wilday Community Champion

01/28/19

Yep, I agree with David. Did adding the last bracket work?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Copying/Exporting Comments and Attachments
Our teams love to communicate updates on their Smartsheets, but I'm wondering what the options are to copy/export these conversations and attachments. We'd like to archive the information into the pro…
Answered ✓
Attachments
Comments and Conversations
Smartsheet Basics
12
Apr 11, 2025
3
SUMIFS & CONTAINS Formula returning #UNPARSEABLE
Advice is greatly appreciated. =SUMIFS({Alpine Master Range 3}, {Alpine Master Range 2}, "Not Awarded", CONTAINS({Alpine Master Range 1} "Chasse", @cell))
Answered ✓
Smartsheet Basics
12
Apr 9, 2025
3
Smartsheet Form QR Code
I created a QR Code using a Smartsheet Form URL; however, the QR Code takes me to a Smartsheet sign-up page instead of the form. I tested this with several QR Code generators. Any idea of what's happe…
Answered ✓
Forms
QR Code
Smartsheet Basics
31
Apr 9, 2025
3

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