Advanced Cross-sheet Formulas

Kimbh
Kimbh ✭✭✭✭
edited 02/06/22 in Formulas and Functions

Hi, new here and still deciding which plan the company should get. I hope to hear from a sales person soon.

Anyway, On this advance cross-sheet. Does it have to add a new column, or can it update an already in column?

Link: https://help.smartsheet.com/learning-track/level-3-advanced-users/advanced-cross-sheet-formulas

Thank you

Kim

Answers

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

    Hi @Kimbh

    I hope you're well and safe!

    Not sure I follow.

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

    Also, let me know if I can help you decide the best plan for your company.

    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 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.

  • Hi @Kimbh

    I agree with Andrée, it would be helpful to know a little more about what you're looking to do.

    Cross sheet formulas look from one sheet into another and can return data based on that other sheet. For example, say you have a sheet tracking tasks, and in Sheet 2 you want to return a count of how many tasks are "In Progress". You could use a COUNTIF cross-sheet formula to COUNT the cells in Sheet 1, like so:

    =COUNTIF({Status Column Sheet 1}, "In Progress")

    You select an existing column in Sheet 1 that's represented {in these}, and then you identify what it is you're looking for.

    The formula itself is input into a cell in Sheet 2.

    Here are some free webinars if you'd like to learn more:

    Cheers,

    Genevieve

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!