Hi @Pugs_Validity and @michael-wtds ,I have a somewhat similar use case would love input on. I would like to update a "Data Source" field on an Upsert import *only* if the record is being created as new. This is a field that aims to capture the platf...
Hi @Pugs_Validity ,Thank you so much for your reply, super helpful. Using the original example, we actually need the formula to do the reverse however, and need to remove the CAD, leaving just 9.90 (ideally without $). Is there an alternate formula t...