I started with help from this support topic:
Formula help for an IF(logical, value1, value2) Formulas
So I’m using a formula in a column to pull data for another table.
This is my formula:
IF({Test Type} = “CAT 1”, {Date ...
As my list of ‘Views’ evolves, I am finding it frustrating that there is no way for a view to inherit the changes I make in another view.
I would find it very helpful to create views in a hierarchy so that changes are inherited by the child view, but...
Thanks @Andy_Lin1
You’re right. [startFromPosition] is optional but, if left out, it defaults to “0” which is the last position, as you said.
Seems counter intuitive to me to ignore all of the preceding values by default. Lesson learnt.
Another thin...
I have stumbled across the solution for this… if anyone can explain it to me I would appreciate it.
The formula: FIND(“SITHFAB002”,{Current Equivalent},0)
…was only returning the correct result if SITHFAB002 was the last value in the string.
By chang...
I see… I had assumed the 1 was a TRUE result of the FIND. Thanks @W_Vann_Hall
It’s working better now, but still not quite right. It seems to only detect the LAST unit code in the ‘Current Equivalent’ string.
Please see record 160 in the attached scr...
There is plenty of room in that title bar to add a little bit of detail…
Maybe some sort of a breadcrumb path to indicate your position on the hierarchy could help:
Thanks @Hashim_Warren. Would be helpful right!
Field Width, Field Order, Field Visibility… would be enough, I’d suggest.
Filter settings might be a step too far. What do you think?
Can’t be too hard to implement, can it?