If Status is "Complete" Fill in #of Stores information into "# Stores Complete

Molly Morton

Hello, I am looking for help writing a formula for: IF Status = Complete - pull value from # of Stores into #Stores Complete Column.

Thanks,

Molly Morton

Andrée Starå

Hi Molly,

Try something like this.

=IF(Status@row = "Complete"; [# of Stores]@row)

The same version but with the below changes for your and others convenience.

=IF(Status@row = "Complete", [# of Stores]@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Molly Morton

This works great... Thanks heaps.

Can you explain the @row?

I have not seen that function

Thanks

Molly

Andrée Starå

You're more than welcome!

@row is used to make the formulas more efficient, and also, you don't need to think about row numbers.

More info:

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!