Luke_TK’s Profile

Community member since June 2017

points
806

1

I am tyring to write a formula for the RYG balls however I cannot figure out how to get yellow to show when I want it between numbers.

 

For example

Red and Green I know  as the below

=IF($[% Complete]3 < 0.5, "Red", IF($[% Complete]3 = 1, "Green"))

 

However how do I get yellow to show up when I

2

I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula:

="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstName1 + " " + SubmitterLastName1 + IF(ISBLANK([Co-creator #1, Name]1), "", ", " + [Co-creator