I have a bot that will send out an email when trigged and then put a date in a column once that task is complete.
The problem I am running into is that until the task is completed the date column is blank but update a row requires a key value for a key column.
Is there anything I can do where it puts in today's date if the cell in the date column is blank
My original idea didnt work well.
I assumed the condition would protect the columns so I sent the Key column to the status column and the key value to the same as in the condition then had an expression for todays date in the Date column
What ended up happening is it updated any date that was already there to todays date and skipped any blanks.
Basically I want to put todays date in the cell only when the statues has that upload message and when the date cell is empty.
664
