-
RAG Ball Status Formula
Hey, I have put together a formula for RAG ball on a project Smartsheet. =IF([Variance2]@row <= -2, "Green", IF([Variance2]@row >= -7, "Red", IF([Variance2]@row <= -6, "Yellow", IF([Variance2]@row = 0, "Blue")) It is half working at the moment except it won't turn blue when there is a zero and for some reason isn't picking…
-
Index only returning results if at the top of the source sheet
Hi All, Hoping someone can help me please? I am using the formula below but it will only work if the search value, System ID, is in the top rows of the reference sheet. =IF(INDEX({Reference Range System ID}, [Row ID]@row) = [System ID]@row, INDEX({Equipment ID}, [Row ID]@row)) What I am trying to do is, If the System ID in…
-
IF OR Formula
I’m creating a symbol field with colors red, yellow and green for risk level. But I have two different totals columns (because we’re either looking at two separate sets of factors to assess risk - we will have a score for either one factor or the other). So I want to write a formula that says IF Cell A or Cell B cell is…
-
Count entries made the previous week
Hi, I am looking to create a sheet summary formula that will count all entries on a sheet that came from the previous week. I figure that it will have to be a countif formula and will incorporate weeknumber but I am lost on how to count from the previous week and have it keep updating for the next week.
-
Automation - need a required for meeting reminder
Hi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and stakeholders which they then reply to if they can make the cal. I have made a required members tab, with multiple contacts in…
-
Change the year of the date when the type of the column is date
Hi, I want to create automation that sends alerts on the day before birthday dates for someone specific. I create a birthday column that is defined as type date. The problem is when the year is past, the year on the date does not update automatically and then I need to update the year. How can I create a formula that…
-
Index and Match with Today functions in a formula
Hello all, Reaching out because I have been trying to build a formula for a sheet summary field, and have had no success. I have seen a lot of smart people on here figure out similar problems, so I believe someone has the answer for me. Basically, I am trying to create an index and match formula that automatically looks…
-
"Status" column to reflect 2nd column input for "Cancelled or On Hold"
I have a Status column that is calculated via an IF statement referencing two other columns, [% Complete] and [Cancelled / On Hold]. =IF([% Complete]@row = "", "", IF([Cancelled / On Hold]@row <> "", [Cancelled / On Hold]@row, IF([% Complete]@row = 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started")))) I…
-
Has anyone created an activity dashboard?
Hola Comunidad, alguien a intentado o a creado un dashboard sobre un reporte de actividades asignadas al equipo de desarrollo teniendo en cuenta tiempos de iniicio, final y status de actividad (completo, en proceso, pendiente, atrasada)??? alguien??? ** Translated via Google Translate ** Hello Community, has anyone tried…
-
Cross sheet references
Is there a way to reference a report summary (count) in another sheet or dashboard? Thanks!