Using Smartsheet for a test series?
I would love to explore if I can use Smartsheet for a end-to-end test series:
As a product manager, I like to provide a set of information pieces to several downstream systems for validation. The first downstream system should be able to see the information that I provided use it to validate and then enter a pass/fail value in a cell.
so I have
- column1 - a item number
- column2 - provided value 1
- column3 - provided value
- column4 - editable value (pass/fail)
- Based on that, the use should enter a pass or fail in column 4
- I like a user to enter 'a item number', see the provided values in columns 2&3
The problem:
If I use Sheet, it seems not very user friendly to enter the information in a column.
I tried the Form, but I don't seem to be able to pre-populate it with a certain test number, so that the test data is displayed.
I also tried to pull the date in a Dashboard, but here I am not able to edit in the dashboard.
Does anyone have any good tips?
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
Answers
-
Hello @Sylvia Kay - You could consider using a report with little or no filters. Smartsheet reports do not allow you to add rows to your sheet, but you can edit cells of an existing row. I use this as a poor man's version of Dynamic View, so I can give users a view of only their test cases and hide any columns that are not necessary while they conduct testing
-
Thank you Scott. Do you know if a Dashboard also allows to change values of a cell?
SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT
PLATFORM ENGINEERING & TECHNOLOGY TEAM
AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL
M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM
follow us on twitter: @AmexGBT
follow us on instagram: @AmexGBT
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives