If Issue Type is Epic then I'd like both the Summary field and Epic Name field to be the same.

Options
Edward Townsend
Edward Townsend ✭✭✭
edited 07/29/21 in Formulas and Functions

I'm using the Jira connector, and I'm using the summary field as the "Title" for each entry. I'd like to Epic Name and the Summary name to be the same so I can hide the Epic Name field from users in the sheet.

If Issue Type is Epic then Epic Name = Summary


Just not sure how to write that?


Thanks

Answers

  • Genevieve P.
    Options

    Hi @Edward Townsend

    You can write an IF statement to do exactly that:

    =IF([Issue Type]@row = "Epic", [Epic Name]@row)

    You would place this in the Summary column.

    However, a column can either house a formula or it can be manually updated, you can't have both. For example, if the Issue Type isn't "Epic", what do you want this value to do? Where is the Summary information coming from? You would need to write that into your formula so that it auto-populates. The moment you manually type into a cell it will remove the underlying formula. Does that make sense?

    See: Create and Edit Formulas in Smartsheet, and IF Function

    To help further, it would be helpful to see a screen capture of your grid in Smartsheet, but please block out sensitive data.

    Cheers,

    Genevieve

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!