Sign in to join the conversation:
I am trying to build a UI using Google scripts to display the changes made to any given row.
In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
You *can* make requests for Cell History, but they are expensive and can sometimes take a long time to process. It is much more efficient to use webhooks on the row to flag you when a row has changed. https://smartsheet-platform.github.io/api-docs/#webhooks
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?
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…
=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.
