Skip to content

Instantly share code, notes, and snippets.

Maxim Shoustin af-fess

  • AppsFlyer
Block or report user

Report or block af-fess

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
toddanglin / Conditional
Last active Nov 10, 2019
Creating Conditional "Icon Set" in Google Sheets
View Conditional

Conditional formula for "pie wedge" icon set

=IF(ISTEXT('Sheet1'!A1), "*", IF(ISBLANK('Sheet1'!A1),'Sheet1'!A1, IF('Sheet1'!A1 >= 10, IMAGE(""), IF(AND('Sheet1'!A1 < 10,'Sheet1'!A1 >= 7.5), IMAGE(""), IF(AND('Sheet1'!A1 < 7.5,'Sheet1'!A1 >= 5), IMAGE(""), IF(AND('Sheet1'!A1 < 5, 'Sheet1'!A1 >= 2.5),IMAGE(""),IF('Sheet1'!A1 < 2.5,IMAGE(""),'Sheet1'!A1)))))))

NOTE: "Sheet1" should be replaced with whatever the target sheet name actually is in your Google Sheets document

You can’t perform that action at this time.