-
IF Function With Multiple Drop Down Selections
I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it. Essentially, when my field team updates the [Field Status] column I want the appropriate colored circle to update in the [Risk Status] column. Red = Delayed Gray = Not Started Yellow = In Progress Green =…
-
IF function to return value based on dates
I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or does it have to be between? For example =IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return…
-
what's wrong with this formula for IF and or
=IF([Total Score]@row >= 3, OR [Impact]@row= yes, OR [Visibility]@row = yes, "Submit", "No") Struggling with this formula in my risk assessment column formula. The Total Score is equal to or greater than 3, or Impact is Yes or Visibility is Yes
-
IF statement for when boxes are checked
Hi! I am a SS newbie and can't figure out what is probably a very simple formula. I am needing my Project Status to change to "Design" when the ALTA Survey Completion is checked actual and/or when the As Built Received Actual is Checked.
-
Need help combining these 2 IF statements
I can get both of these to work separately, but when I try combining them, using IF(OR or IF(AND or even just another IF(, the "Yellow" part won't work. Suggestions, please? =IF([Milestone Due Date]@row > ([Today Helper]@row + 30), "Green", IF([Milestone Due Date]@row > ([Today Helper]@row + 7), "Yellow", "Red"))…