Hi All,
Need a small help.
In the data, say i have columns A-H and rows 1-8.
If, say, value in F6 < 1000, then all the data in row 6 need to be changed to 0.
Thanks in advance
Solved! Go to Solution.
Hey @Shahas, you could handle this with a Multi-Field Formula like so. If you want to do this based on the value of a different cell then you just need to change where I have [F] = and [RecordID] = 6 to be your column and row of interest:
F6 = 1001, no change:
F6 = 500, whole of row 6 made 0:
Hope this helps!
Thanks @DataNath . It worked.