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 appropria…
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 …
=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 t…
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…
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]@r…