The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi all.
Sure this is super simple and I’m no doubt being super simple myself in not getting the solution…
I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet
Col 1 [$ Charge]
Col 2 [currency...
Hey Mo - realised if I just drop 1 into the FX Rate field, then it’ll solve that problem.
Which actually means I might as well just simplify this and not use IF formula. If I’m going to have the FX Rate field, then I just do a straight multiple Fiel...
Hey Mo! Thanks for your quick reply.
I dropped this in with the new field. It seems to work for the second condition but not quite for the the first.
So with the adjusted fields:
Field 1 ($ Charge) = $1.50
Field 2 [Currency) = AUD
Field 3 [FX Rate]...