Using Smartsheet for a test series?

Sylvia Kay

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?

Scott Peters

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

Sylvia Kay

Thank you Scott. Do you know if a Dashboard also allows to change values of a cell?