MAX using IF

Options

rdipaola

rdipaola ✭✭

10/17/18 edited 12/09/19 in Smartsheet Basics

I need to find the Maximum value in a range given a value is matched in another range.

If the job code matches in column A then give me the max in column B

0 ·

Comments

Paul Newcome ✭✭✭✭✭✭

10/18/18
Options
Could you give more details and/or some screenshots?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…
Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?

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