bonjour à tous,
Je débute dans AppSheet. Avant j’utilisais OpenAsAPP qui est vraiment plus intuitif.
je souhaite savoir comment faire pour que mon appli Appsheet ressemble à ca :
Hello Cyril,
Bienvenue la communauté !
Il vaut mieux poster en anglais généralement si tu veux avoir une réponse, nous sommes minoritaires en français
English speakers:
a simple point-by-point system using either a checkbox to validate or not the steps one after the other in this survey.
Once validated, this gives us a score in%
About answering your question:
You may want to use the Show_If condition for each column, i.e. :
for column2 : ISNOTBLANK(column1])
for column3 : ISNOTBLANK(column2])
etc.
To do so:
click on the black pen of each column
In the end, the % result will be basic mathematics.
Depending on your need, you may want to use a virtual column or use a real column on your sheets.
Please note a Percent type is available, you may want to use it for this column.
Also, please note you may rather use Google Sheets instead of MS Excel spreadsheets, as you will face less issue in the future.
Let us know if that works for you
EDIT : additional information about percentage question
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |