Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
VLookup or not
Im working on a scrum dashboard and want to show the actual sprint name.
The Sprint Name (e.g. Sprint 01, Sprint 02...) is in the primary column at Level 2 (task at Level 3 and Release at Level 1). I have a column with the status ("Do", "Doing", "Done") and only one Sprint can be in the "Doing" status.
On my metrics sheet I can to calculate a cell which give me the name of the sprint which is in Diong and later on the dashboard I will use this cell to show the text "Sprint 01".