Welcome, Guest
Username: Password: Remember me

TOPIC: IF formula that checks for icons in a field

IF formula that checks for icons in a field 2 years 8 months ago #6787

  • brettm
  • brettm's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 30
I have a formula that checks a column for what level a child is in and then calculate their percentage result on their spelling test. See image that I have included with this post (hopefully it worked!)

If the student is away, I put an icon in the field and no result.

How do I write a formula that checks for an icon and returns an icon in the calculation cell or the words "Away" please?

IMG_1458.png
The administrator has disabled public write access.

IF formula that checks for icons in a field 2 years 8 months ago #6792

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
Hi,
You will see here how to count icons in a formula, the third method. Regarding the 'Away' or icon result, it can't be done yet. But you can count on it for our next update. We'll contact you once the beta is available in case you'd like to give it a try.


Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.
The following user(s) said Thank You: brettm

IF formula that checks for icons in a field 2 years 8 months ago #6797

  • brettm
  • brettm's Avatar
  • OFFLINE
  • Skilled member
  • Posts: 30
Yes please ... would love to try this Bert when Beta is available.

Thank you as always for the amazing support - iDoceo is THE product that I cannot live without in my classroom.

Brett
The administrator has disabled public write access.

IF formula that checks for icons in a field 2 years 8 months ago #6798

  • bert
  • bert's Avatar
  • OFFLINE
  • Admin
  • Posts: 2950
  • Thank you received: 530
You will receive the Testflight/Apple invitation in a few minutes.
You can either install the current Beta and receive automatic notifications about the next updates or keep an eye on the TestFlight app for 'What's new' in the following releases.
Please take a moment to add or update your rating for iDoceo 5 teacher gradebook so that we can continue working on it. Thanks!
Here is the link
itunes.apple.com/us/app/idoceo-teachers-...&action=write-review
The administrator has disabled public write access.
Time to create page: 0.120 seconds
13 APR

iDoceo 5.1 is now available!

An amazing update with tons of new features. Audio questions in iDoceo Connect, countdown timer, feedback and more

Read more

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template

Read more