Update Requests

LUCA GALLEGO

I would like to have a update request go out when the value of a cell in a column goes bellow the number in a cell in another column in the same row, im wondering if this is possible. I cant find a way to do so. the catch is the numbers will be different for every row so i cant use one specific number which is the only option I can find.

LUCA GALLEGO

I have found a work around using the status ball

LUCA GALLEGO

I have found a work around using the status ball

Ray Lindstrom

Hi @LUCA GALLEGO,

You can add a helper column to do the evaluation, and then add the Update Request workflow based off the value of that column.

For instance if you use a checkbox column you could use this formula with your column names:

=IF([Value 1]@row [Value 2]@row, 1, 0)

Then create your workflow to look at the checkbox column value.

"When rows are change"

"When Checkbox value changes to "Checked".

Then you can select Update Request and customize your message.

Ray Lindstrom

@LUCA GALLEGO,

Guess you found it while I was replying. Glad you got it to work!

All the best,

-Ray