-
Count Check marks across columns
Hi I'm relatively new to SmartSheet and have a question. I have a set where each row represents a requirement. Each requirement may impact multiple systems. Since I'm unable to select multiple entries with a drop down - I've created 4 column - each representing an impacting system. I now need to summarize in a dashboard…
-
Nested IF Formula with Blank Cell Condition
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([Proj. Blended Average]4 >= 0.76, "Yellow", IF([Proj. Blended Average]4 <= 0.75, "Red"))) However, I am struggling to find a…
-
Formula help
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 column A, column B prints today's date plus 90, and if I choose Tax it prints today's date plus 60 Thanks for your help
-
Can we create a formula using a cell that has an IF statement in it?
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 keep getting #INVALID. The only thing I can come up with is that it's not allowed to use the information that is…
-
RYB Formula Help
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 project status is. Both columns have gray, red, yellow, and green balls. This is my current formula please help if you can.…
-
Using OR in a SUMIFS or COUNTIFS Function
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 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…
-
Count Unique SME names
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 to count the number of unique names in both columns. SME #1 (Name) | SME #2 (Name) Course 1 | Donald Duck | Course 2 |…
-
Count number of checked in a sheet
Hi Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?
-
RYG Status based on Variance
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 the formula? Thank you!
-
Special IF Formula for Stars
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's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…