Trending in Formulas and Functions
-
Formula Help
Need help with this formula: I have a YES/NO category and if the answer is YES then I want to add all the columns listed below, if the answer is NO then I want the column to show $0. =IF([Exterior Signage (YES/NO)]@row, YES, Exterior Survey Cost]@row + [Door Vinyl Cost]@row + [Privacy Screen Cost]@row + [Illuminated…
-
RGBY formula
Need help… For the Epex Ready field, I want the ball in the cell to either be red or green. It should only turn green when the 3 fields that proceed it turns green. Any help is greatly appreciated.
-
Can someone tell me what I am doing wrong in this formula to set the status ball color?
=IF([Estimated or Actual Finish]@row>Finish@row), "Yellow", IF(AND([% Complete] < 1, Finish@row < TODAY()), "Red", "Green")