Hi @Torus_Global, Torus_Global: So how do I get the SUM of ALL Converted values into the formula? You can’t. Unlike excel, formulas can reference cells from only one row at a time. What you can do is to calculate the profit for each row and th...

Hello @111257, welcome to the community :slightly_smiling_face: . I’m not sure what the script is trying to do but there are some semantic errors. E.g. stocks[i] will return the ith item which will be undefined since it doesn’t contain any objects ...

To construct URLs use ENCODE_URL_COMPONENT because it encodes not only spaces but other URL-unsafe characters as well. So maybe something like this will work: IF(OR({Work Submission Pseud} != {Synced Participant}, {Assigned Writer(s)} = BLANK()), B...

Hi @nisha_elliott your formula should work. nisha_elliott: How do I make sure “Apples - Michigan” doesn’t break the URL ENCODE_URL_COMPONENT does exactly that. What URL is generated currently?