Auto populate a cell when inserting a new row

06/15/21
Answered - Pending Review

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.


Thanks in advance!

Answers

  • Kelly DrakeKelly Drake Overachievers

    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.

    Kelly Drake (she/her/hers)

    STARBUCKS COFFEE COMPANY | senior project manager | global growth & concepts

  • Thanks Kelly - that is what I thought.

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

  • 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.

Sign In or Register to comment.