Trending in Formulas and Functions
-
Text String Help... Again!!
Hello All, feel like I am always asking these text string questions but they are so confusing!!! I have a list of retailers and I am trying to just extract the Name of the retailer between either the 1st and 3rd "-" or the 1st and 2nd "-". The problem is with how some of these are formatted like the first one and second…
-
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")
-
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…