Welcome!

Formulas and Calculations

Duh!! I figured it out. It was simple.

Dennis

Formulas

Hi Dennis,

Excellent!

Glad to hear that you got it working!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Workaround for =HYPERLINK
Each row has a unique ID and I use this to generate two different hyperlinks in excel with this =HYPERLINK(CONCAT("http://www.XXXXX/",A3),"URL") Is there a workaround in Smartsheets to do similar?
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
Range settings
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.