Hi I'm trying to use a nested formula to calculate a risk matrix if an entry has different conditions: F({ Platform product data sources (from Submissions)} =Platform Product/Data, OR ({Subproccessor (from Submissions)}=Subprocessor), ‘CRITICAL’,IF (...
This unfortunately is not working for me. How does the concatenate and Switch functions work in nested formulas?it seems the argument for subprocessor to be idetnified as critical is working well, but not the others
Thanks @Sho I then went to build on this formula as follows, but I am not getting any valid results for the logical arguments to return "medium.." or "high" criteria, only Critical, and Low (the last argument). could you please help? Am I missing/usi...
Unfortunately this doesn't seem to be working. I am wondering if the problem is that I'm referencing fields from a lookup field? Do I have to create an array/flatten? the corrected fields are as follows: IF( OR( { Vault Platform product data sources ...
