Dynamic file name creation with formula

Current formula is below. I get an extra hyphen between project name and size if the row is a level 2.or 3. I can't figure out how to not have an extra hyphen. Not sure if I need to add OR statement so it looks at each level then pulls the correct information. The file name should be Job#_Project Name_Size

=IF(Level@row >= "3", INDEX(ANCESTORS([Job #]@row ), 1), [Job #]@row ) + "_" + IF(Level@row >= "2", [Project Name]@row , "") + "_" + IF(Level@row = "1", [Project Name]@row , "") + "_" + [Size (WxH)]@row

Result: PRAFI_001207_DOM25_Breakout01_RetractableBanner__24x81

Find more posts tagged with

Accepted answers

Paul Newcome

Try moving the last underscore into the IF for level 1:

=IF(Level@row >= "3", INDEX(ANCESTORS([Job #]@row), 1), [Job #]@row) + "_" + IF(Level@row >= "2", [Project Name]@row, "") + "_" + IF(Level@row = "1", [Project Name]@row + "_", "") + [Size (WxH)]@row

All comments

Andrée Starå

https://community.smartsheet.com/discussion/140010/dynamic-file-name-creation-with-formula

Hi,

I hope you're well and safe!

Try changing all the "_" to something else for each so you can easily see where the issue might come from.

Make sense?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Paul Newcome

Try moving the last underscore into the IF for level 1:

PDunn

@Paul Newcome Yes that worked perfectly Thanks Paul and Andree always for your insights and quick responses

Andrée Starå

https://community.smartsheet.com/discussion/comment/486470#Comment_486470

I'm always happy to help!

✅ Remember! Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.