Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
9 months ago

Case Formula Assistance

Please make this work. thank you

Case(
[Task]="PRIME" and [Take/Off Calc - CALCULATION TYPE]="CEILING.HSF",[Take/Off Calc - CEILING CALC HSF],
[Task - Task Phase]="Paint.Interior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT])



------------------------------
BuildPro
------------------------------
  • np, just change CASE to IF and it should work. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain

      Thank you...silly me!



      ------------------------------
      BuildPro
      ------------------------------