If Issue Type is Epic then I'd like both the Summary field and Epic Name field to be the same.
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
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!