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

Edward Townsend

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

Genevieve P.

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