Auto populate a cell when inserting a new row

RSP

Hi all,

I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank.

Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible.

Screenshot 2021-06-15 at 17.35.44.png

Thanks in advance!

Kelly Drake

I've tried using the Update a Cell automation (which is what I think you're looking for here) but right now that feature doesn't allow you to update cells in symbol columns. (I recommend submitting a feature request!)

I'm not sure you can solve the issue without using a formula or manually editing though. Unless you would input new rows using a form and you make that column a hidden field with the default value of the green ball.

RSP

Thanks Kelly - that is what I thought.

I shall submit a feature request and complete this action manually for now.

RSP

It also means I can't update the RAG status based on % complete i.e. I update % complete to 100%, the symbol turns into a blue circle 😥

For me personally, this is quite a big miss. They are nearly there with the "change cell value" automation but I am not sure why it is only the text / number field that can be changed here.