How to automatically assig task to a person if it meets the criteria in column A?

Leod13

Hi All,

I'm looking for a way to assign a task to a person if the criteria in column A are met.

KPH

You can use an IF function in the assignment cell.

Type =IF

Then enter the logic you need regarding column A

And then the person to assign it to if that is correct.

Or, if you have a list of criteria and names somewhere else you can use INDEX and MATCH or COLLECT to return the name of the person that meets the criteria.

Check out

IF Function | Smartsheet Learning Center

INDEX Function | Smartsheet Learning Center