Advanced Cross-sheet Formulas

Kimbh

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

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!

Genevieve P.

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:

• Formulas webinar series
• Connect Live Data Across Sheets

Cheers,

Genevieve