Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any way I can create a custom value on the table that will affect the value?
Date | Name | Salary | Adjusted (Custom Column) | New Salary |
---|---|---|---|---|
11 jan | james | 1500 | 20 | 1520 |
14 jan | mary | 2222 | 111 | 2333 |
28 jan | peter | 3333 | - | |
15 may | jon | 40 | 40000 | 40040 |
The adjusted colum is the colum that I want user to input value that will affect the result of the salary on the pivot table,
is there anyway i can do that>
thanks
You can input values see the example below
1.Create input field (field you want use a input) in script
INPUTFIELD fieldname; // like how you create let, set field
2. After reloading in table
INPUTSUM(your input field) //As field in step 1
3.For your new salary column use
inputsum(INPUTSUM(your input field))+Salary