MAX using IF

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

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

How to reopen Worskpace Panel
I closed the Workspace Panel so it wasn't blocking my sheet columns. Now I want to reopen it but I don't see that option. How do I fix this? Also, I uploaded logos to various Workspace to distinguish between clients I am working on. Now that I closed the Workspace Panel, I no longer can see the logo.
Is there a way to stop automations when the person being notified is the person that trig
Is there a way to stop automations when the person being notified is the person that triggered said automation?
Field not showing on automation workflow
Hi there, I'm trying to create an automation workflow to check a "checkbox" field when the task in that row is past due; however, when I create the workflow, the checkbox column that I created is not showing as one of the options on the final screenshot below. Any ideas why? (workflow setup) (column not showing)

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