Hi, I was able to get this formula to work, where: * 90% or higher = Green RYGG ball * 76% to 89% = Yellow RYGG ball * 75% or lower = Red RYGG ball =IF([Proj. Blended Average]4 >= 0.9, "Green", IF([Pr…
Hello everyone I hope you are doing great. I need help with creating a formula for the following. I have a drop-down list, with two items, Zakat and Tax. I want to able to if I choose Zakat from the c…
I have a pretty long IF statement in a cell and want to use the results from that cell in a formula for another cell. The formula I am trying to create is VERY simple; 2 cells multiplied together. But…
I am having issues with developing a formula for an overall status. What I'm trying to do is based on multiple cell-status(RYB setup column) they will dictate what the overall status column of the pro…
Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 crit…
Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row). I'd like …
Greetings, Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget. Any ideas on th…
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it'…
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations…
