Hi all
PowerApps / Sharepoint beginner here.
I realise this is a PowerApps forum but I'm unable to move forward to PowerApps without resolving this issue with SP, so I'm hoping someone can help.
In Sharepoint I've created a list with which I intend to build an app in Power Apps.
I've been trying out different formulas with no success and am hoping someone here can help. I can't move on to PowerApps until I sort this, I'm pretty sure the answer is simple but at present it is beyond me.
Best wishes
Martin
Solved! Go to Solution.
Try the following in the rating column. Make sure both rating and total are numeric columns
=IF(source<6,1,IF(source>10,3,2))
For that you can expand the pattern of the formula with another If statement like this
=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))
Try the following in the rating column. Make sure both rating and total are numeric columns
=IF(source<6,1,IF(source>10,3,2))
How does the forumual change if I have four ratings?:
If the 'total' is between 1 and 5 then the rating should be 1
If the 'total' is between 6 and 10 then the rating should be 2
If the 'total' is between 11 and 15 then the rating should be 3
If the 'total' is between 16 and 20then the rating should be 4
Many thanks
For that you can expand the pattern of the formula with another If statement like this
=IF(source<6,1,IF(source>15,4,IF(source>10,3,2))
User | Count |
---|---|
184 | |
122 | |
91 | |
47 | |
42 |
User | Count |
---|---|
271 | |
159 | |
130 | |
85 | |
78 |