IF statement for personal template
I am looking for some advice on how to use a IF statement on a template that my team will use, but it needs to be set up part-way in the template.
For example, I want the column Quantity Budgeted to show a different number based on the selection in the Group column.
If the group column is Apple, I want Quantity Budgeted to show 4.00
If the group is Banana, The Quantity Budgeted to show 7.00
The # that will show is going to be different each time someone uses the template. That is what will be on a case-by case basis.
ALSO, there is another column that is using the number being populated in the Quantity Budgeted column.
Quantity Remaining column = Quantity Budgeted column minus Quantity (per month) column.
Answers
-
You need to learn Nested IF statements and SUM statements:
Instead of SUM, you can also do something like:
=[Quantity Budgeted]@row-[Quantity (per month)]@row
-
Thank you. I made the following formula:
=IF(UOM@row = "MONTH", "3.00", IF(UOM@row = "PLAN", "1.00", IF(UOM@row = "STUDY", "1.00", IF(UOM@row = "MEET", "2.00", IF(UOM@row = "REVIEW", ""6.00", IF(UOM@row = "VENDOR", "2.00", IF(UOM@row = "VISIT", "1.00", IF(UOM@row = "LAB", "1.00", IF(UOM@row = "QUARTR", "11.00", IF(UOM@row = "REPORT", "1.00", IF(UOM@row = "EA", "204.00", IF(UOM@row = "TRANSF", "12.00", IF(UOM@row = "IMAGE", "1224.00", IF(UOM@row = "SAP", "1.00", IF(UOM@row = "TLF", "7.50", IF(UOM@row = "TABLE", "35.00", IF(UOM@row = "LIST", "5.00", IF(UOM@row = "FIGURE", "2.50", IF(UOM@row = "TFL", "INPUT")))))))))))))))))))
But it's coming back #UNPARSEABLE
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!