Any way to link cells in same smartsheet using create link option?...% column doesnt take formulas

student1
student1 ✭✭
edited 05/16/23 in Formulas and Functions

% complete column does not include any formulas….but want to link the task % complete with some other cells in same smartsheet

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 05/16/23

    Hi @student1

    I hope you're well and safe!

    Not sure I follow! Can you elaborate?

    Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • @Andrée Starå

    Hey…Thanks for Responding!

    I want to link calculated Percentage cell to % complete

    For Example Instead of 40% it should take value from its adjacent cell which is 100% but since % complete column does not allow me to use any formulas to link that cell ( Using "=" )…if I want to create a link for this purpose smartsheet does not allow to link cells in same Smartsheet

    Hope it clears my question

    Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!