Hi,
This is my SP List,
Before Completing Selection
Position | Openings | Status |
Developer | 2 | In-Progress |
After completing Selection,
Position | Openings | Status |
Developer | 2 | Completed |
After status getting completed i need to update a Openings into "O".
How to update this?
Thanks,
Dhinesh
Solved! Go to Solution.
Hi @Dhinesh28R ,
What's the column type of your Openings and Status column?
Do you want to change Openings to a text "O" or to a number 0?
I assume that the Openings column is a Number column and the Status column is a Choice column, and you want to change it to number 0, so you can try this formula:
UpdateIf(listname,Status.Value="Completed",{Openings:0})
If this is a Text column, try this formula:
UpdateIf(listname,Status.Value="Completed",{Openings:"O"})
Best regards,
Allen
Hi @Dhinesh28R ,
What's the column type of your Openings and Status column?
Do you want to change Openings to a text "O" or to a number 0?
I assume that the Openings column is a Number column and the Status column is a Choice column, and you want to change it to number 0, so you can try this formula:
UpdateIf(listname,Status.Value="Completed",{Openings:0})
If this is a Text column, try this formula:
UpdateIf(listname,Status.Value="Completed",{Openings:"O"})
Best regards,
Allen