I want to add a new column with the some data to all rows by default

[Anonymous]

Mornin All

I want to add  a clumn to my data-set.

Its just a URL like https://app.asana.com/0/xxxxxxxxxx/

I will do some concatenation after this and Im happy with this; but whats the best way to have the above URL automatically in every row by default even when new rows appear. (after a refresh)

Should I just do a switch fucntion on a column I know will never be blank and if it isnt blank add the above URL?

Cheers

Jimmy

[Anonymous]

Hi @Anonymous 

Can you provide some sample and the ooutput you want so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I was over thinking

PROJECT LEVEL URL = IF(ISBLANK(ADMIN[Task Name] ),"Blank","https://xxxxxxxxxxxxxxxxxxxxx")