Changing a cell's values from code in a different cell

06/25/19 Edited 12/09/19

Is it possible to change the value of a certain cell using code in another cell.

I would imagine it looking similar to this format..

IF([email protected]=X, different_cell=XX, different_cell=XXX)

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Logan,

    Yes, it's possible! How would you like to use it?

    Hope that helps!

    Have a fantastic day!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • edited 06/25/19

    In the end I would like to have a function that tests "if" [column1]@row=1 then [columnX]@row=[columnX]@row-1

     

    Testing if a condition is true, if it is then assigning the value of a cell to be the value of the cell directly above it.

    BUT because of how I am gathering the data in forms, this formula cannot be put in the cell that is getting changed, it needs to be in a different cell or if there is some kind of script function I could run.. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 06/27/19

    Ok.

    You would need to add at least one so-called helper column, and if I understand your need correct, you won't need to script anything to make it work.

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • i have a spin off of the same question.

    column 1=date , column 2=mods number, 3=helper.

    Helper= =IF(mods522 = "", "mods empty", IF(date522 <> "", "date empty T", TODAY())).

    then i was trying to today's date in Date column from this cell.

    i tryied workflow to do this but they did not like it because you had to save and refresh (sometimes twice).

    is this possiable?

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 12/28/21

    @Stephen Hindes

    I've answered your new post.

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.