Case Formula Assistance

Question

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------------------------------

markshnier__you · Answer

np, just change CASE to IF and it should work.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

buildpro · Answer

Thank you...silly me!------------------------------BuildPro------------------------------

Forum Discussion

Case Formula Assistance

2 Replies

Related Content

Assistance Needed to Locate Formula Fields which include Specific String

Formula URL - Edit then Add

Formula Assistance - Comparing Two Dates

Calculating Percentage Average of Consent Date Entries: Seeking Formula Assistance

Formula assistance

Recent Discussions

Bug with Advanced Query in Pipelines Designer?

Date value changes when copied to new table with pipeline.

Share your feedback on the new Qrew Discussions

'Is Set' in Pipelines

Time of Day field values are not in 24-hour format in Pipelines