Help: Formula Creation Request Please

Collin Ice

Can someone help me by typing out what I hope is a simple formula? End result, when I update my "Status" column, I want it to enter the following amounts in my "% complete" column. FYI, Status is a drop down single choice column type. I will be so appreciative! I just don't time to figure it out by trial & error. Example below:

Pending PO Creation - 10%

Pending Shipment - 25%

Partially Received - 50%

Received Site - 100%

Rodolfo Garcia

Hello Collin

1. Status Column in dropdown with your status
2. % Complete use the format in your tool bars to set the format to percentage.
3. Use nested IF Functions, using decimals for each status

I hope it helps

Regards

Rodolfo Garcia

Collin Ice

Thank you very much and I'm in business now. How exciting!! It worked this time and even better, the logic behind creating it makes sense now as well. It would be incredible if Smartsheet would make these (seemingly) simple tasks easier w/o the requirement for formulas. We have conditional formatting and to me, this is very similar. Thank you Rodolfo!

Rodolfo Garcia

Hello Collin

1. Status Column in dropdown with your status
2. % Complete use the format in your tool bars to set the format to percentage.
3. Use nested IF Functions, using decimals for each status

I hope it helps

Regards

Rodolfo Garcia

Rodolfo Garcia

@Collin Ice

Rodolfo Garcia

Please let me know your thoughts @Collin Ice

Collin Ice

Hi Rodolfo. I can't wait to try it on Monday and will let you know. Thanks very much!

Collin Ice

Hi Rodolfo,

It's coming back with Unparseable. Here is my formula based on your feedback. Where did I go wrong? Thank you!

=IF(Status@row = "Pending PO Creation", 0.1, IF(Status@row = Pending Shipment", 0.25), IF=Status@row = "Partially Received", 0.50, IF=Status@row = "Received Site" , 1))))

Rodolfo Garcia

@Collin Ice

Hello, sorry for the delay

here is one approach, that runs according your needs

As I can see, the status text should be between "text".

The parenthesis should go at the end

After IF is located an open parenthesis

Here is the image

Please if it works mark in vote Up to help others to find a solution.

Best Regards

Rodolfo

Collin Ice

Thank you very much and I'm in business now. How exciting!! It worked this time and even better, the logic behind creating it makes sense now as well. It would be incredible if Smartsheet would make these (seemingly) simple tasks easier w/o the requirement for formulas. We have conditional formatting and to me, this is very similar. Thank you Rodolfo!