Formula Help - IRAAD Profile Data + IRAAD ID
Hello Smartsheet Community
Just needing a little more formula help. I have an IRAAD that is being provisioned through a control center blueprint. In this IRAAD I need to add a column formula under the IRAAD Identifier Column. I need to create a unique identifier that takes the Business Partner Alias Profile Data under the detail's column (row 3) and combine it the auto numbered IRAAD ID.
So, the IRAAD identifier column for each entry would have something like "IRAAD0004 - Alias" I need to formula to only create the unique ID if the IRAAD ID @ Row in not blank.
If anyone has any ideas on how to put this together, I would greatly appreciate it.
Thank you as always. This Smartsheet Community group is so incredibly helpful and has saved me so much time trying to figure out. I truly appreciate the help.
Help Article Resources
Check out the Formula Handbook template!