Create a Table like survey for some user

[beycos]

Hello Community, 

I want to transfer this excel table that I have attached  to ServiceNow.

The user should complete this table in ServiceNow. In the survey table, There are 5 options under the impact category: X/Y/Z/B/A. For each impact category options, there are 8 options  ( < 10 min/< 1 hr/< 6 hr/< 24 hr/< 3 days/< 7 days/< 30 days/> 30 days.) For each of the 8 options, up to 6 choice (from 0 to 5) can be selected. 

How to transfer this excel table  to SN?

I would be very grateful if you could give me some advice on this matter. Thank you very much in advance.

[Dr Atul G- LNG]

Hi @beycos 

Greetings!!

On very high level, it is just 2 fields, Like category and Subcategory and the screen shot your shared is Pivot table which we can create in SN.

Create a Table

Create 2 fields 

populate data in same.

[beycos]

Thank you Atul for your quick response. Could you please give me some more details please?

Thank you 

[Dr Atul G- LNG]

Hi @beycos 

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/administer/table-administr....

https://youtu.be/PiqySDp-6io

https://youtu.be/-dZvYnpuz3E

[beycos]

Thank you Atul again .

I have watched your videos and they were really helpful. I have already created an impact calculation table and attached it. However, every time I clicked "new" I can  only add one impact  category. All impact categories should be filled in by user as a set of question. One record should be created with these 5 options.(x/y/z/b/s) After creating the record, I need to configure more calculations for each record.

If you have any ideas ,I would appreciate it.