IF, THEN for stock inventory
Hi, I'm really new to this but couldn't seem to see in the forums  I've set up a PPE stock request form for the teams to fill out  which autopopulates in the respective columns, including the multiselect PPE column.
What I'm trying to do is set up an IF something is requested, THEN the columns which has the current stock levels will remove 1. But I don't know how to write the formula. I have tried: =IF[PPE:PPE],1"HARD HAT", 1[Hard hat:Hard hat]
Or can anyone advise on a formula that accounts for multiselects to be counted because if they select for example, a hard hat, XL vest and safety glasses, how should I write the formula please?
Answers

You are going to need to manually enter your starting inventory somewhere. That could be in another cell on the sheet, a Sheet Summary Field, or manually entered directly into the formula.
For this example, I will say you are starting with 25 Hard Hats and will have the starting inventory directly in the formula.
=25  COUNTIFS(PPE:PPE, CONTAINS("Hard Hat", @cell))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!