NBurrus’s Profile

Community member since October 2018

points
184
Company
Stria, LLC http://stria.com
About Me
My name is Nick and I am a Quality Assurance Coordinator over at Stria, LLC a Business Process Acceleration firm. I work with Smartsheet full time for my business. When I have spare time I'll help answer questions!

I specialize in document recognition and automation. We just use Smartsheet to track our work!

2

Oh COME ON!

Why why would you change a keyboard shortcut?

Are you aware of muscle memory?

This just sadistic.

Isn't this one of the golden rules of hot-keys? 

They don't need to "make sense" and you shouldn't need to or ever really be able to guess them.

WHAT COULD POSSIBLY BE THE REASON TO CHANGE

4

Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form.  In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this..

3

Can someone show me how to use a VLOOKUP for the highest value?

For example:

=VLOOKUP(LARGE([% of Target]1:[% of Target]16, 3), Name1:[% of Target]16, 2)

 

Basically by the LARGE([% of Target]1:[% of Target]16, 3) I am returning a value of 52% (which is the third highest value). This is automatic.