Hello - been struggling with this one, beginning to think it's not possible within smartsheet.
I am trying to create an IF statement where if you select a certain value from the dropdown column "Recruitment Team Alignment", it populates the "RTA Code" with a certain number. Here is the formula i've tried.. I'm worried it may be too long.. 18 different selections..
=IF([Recruitment Team Alignment]@row = "AMS Central", 100, IF([Recruitment Team Alignment]@row = "AMS Sales", 200), IF([Recruitment Team Alignment]@row = "AMS Corporate Functions", 300), IF([Recruitment Team Alignment]@row = "AMS ONEx", 400, 0), IF([Recruitment Team Alignment]@row = "AMS Engineering1", 500), IF([Recruitment Team Alignment]@row = "AMS Engineering2", 600), IF([Recruitment Team Alignment]@row = "AMS Engineering3"), 700), IF([Recruitment Team Alignment]@row = "AMS Director Plus", 800), IF([Recruitment Team Alignment]@row = "AMS Sourcing", 900), IF([Recruitment Team Alignment]@row = "APJC", 1000), IF([Recruitment Team Alignment]@row = "EMEA", 1100), IF([Recruitment Team Alignment]@row = "ETR", 1200), IF([Recruitment Team Alignment]@row = "H&E", 1300), IF([Recruitment Team Alignment]@row = "ID&A", 1400), IF([Recruitment Team Alignment]@row = "Global HQ", 1500), IF([Recruitment Team Alignment]@row = "People Movement", 1600), IF([Recruitment Team Alignment]@row = "Strategy & Operations", 1700), IF([Recruitment Team Alignment]@row = "Transitions", 1800))
I've also tried..
=IF([Recruitment Team Alignment]@row = "AMS Central", 100, [Recruitment Team Alignment]@row = "AMS Sales", 200, [Recruitment Team Alignment]@row = "AMS Corporate Functions", 300, [Recruitment Team Alignment]@row = "AMS ONEx", 400, [Recruitment Team Alignment]@row = "AMS Engineering1", 500, [Recruitment Team Alignment]@row = "AMS Engineering2", 600, [Recruitment Team Alignment]@row = "AMS Engineering3", 700, [Recruitment Team Alignment]@row = "AMS Director Plus", 800, [Recruitment Team Alignment]@row = "AMS Sourcing", 900, [Recruitment Team Alignment]@row = "APJC", 1000, [Recruitment Team Alignment]@row = "EMEA", 1100, [Recruitment Team Alignment]@row = "ETR", 1200, [Recruitment Team Alignment]@row = "H&E", 1300, [Recruitment Team Alignment]@row = "ID&A", 1400, [Recruitment Team Alignment]@row = "Global HQ", 1500, [Recruitment Team Alignment]@row = "People Movement", 1600, [Recruitment Team Alignment]@row = "Strategy & Operations", 1700, [Recruitment Team Alignment]@row = "Transitions", 1800)
