Help: Formula Creation Request Please
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%
Best Answers
-
Hello Collin
- Status Column in dropdown with your status
- % Complete use the format in your tool bars to set the format to percentage.
- Use nested IF Functions, using decimals for each status
I hope it helps
Regards
Rodolfo Garcia
-
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!
Answers
-
Hello Collin
- Status Column in dropdown with your status
- % Complete use the format in your tool bars to set the format to percentage.
- Use nested IF Functions, using decimals for each status
I hope it helps
Regards
Rodolfo Garcia
-
Please let me know your thoughts @Collin Ice
-
Hi Rodolfo. I can't wait to try it on Monday and will let you know. Thanks very much!
-
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))))
-
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
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hi! I cannot figure this out. I have a "% Complete" column (0, 25, 50, 75, 90, 100, Cancelled). I made a simple checkbox column that should be checked if the item's "% Complete" value is equal to anyt…
- This formula keeps coming up as #UNPARSEABLE. I have checked the name of the columns, they are correct. Any ideas? I am trying to show the days remaining in a project. =IF([% Complete]@row = 1, "", NE…
- Hi All! I´m trying to find the error in this formula but have not been able to find the solution after many attempts. Any ideas? =IFERROR(IF([To Date]@row <> "", IF([To Date]@row < TODAY(), "RED", IF(…
