Default value for blank cells in column

Allie12380 · 02/13/25

I am trying to create a workflow. A file imports into one sheet that has appointment data. There are multiple workflows that send the data to the appropriate scheduler. So the scheduler only sees the appointments they need to work. On the individual sheets, added a column called Assigned to. It is blank when the row is created. Tried to create a workflow that says when Assigned to is blank change cell value in Assigned to column to Not Assigned. My issue is in the workflow can't have it look at and update the same column.

Question 1: Should I be able to set up a workflow that can find blanks in column and update within that same column?

Question 2: Would I need to add a helper column called Assigned Status that says if Assigned to is blank = True; if not False. Then workflow that says if Assigned Status is True (aka blank) update Assigned to field to Not Assigned?

Paul Newcome · 02/14/25

Try an "Assign People" action instead of a "Change Cell Value".

Paul Newcome · 02/14/25

You should be able to do it in the same column in a single workflow. Are you able to provide some screenshots for context?

Allie12380 · 02/14/25

Below are the automation screen shot:

For workflow I am saying when "Assigned to" is blank change cell value in "Assigned to" to "Not Assigned." However, when I do change cell value action and click down arrow on change cell value in ["Assigned to" is not in the list]. Inserting the "Not Assigned" is a preference to see words verses the blank cell.

Truncated Sheet view: