New here, general questions

Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools.

While I'm here, it is possible to upload to a file to overwrite (update) data on a current sheet?

Can I sync two sheets so when one updates both will update?

Where do I find a list of app's I can use, if those are available?

Thank you

Kim

Find more posts tagged with

Calendar View

Formulas

Automations

Accepted answers

All comments

Jeff M.

Check out this dashboard for your for a list of formulas with examples. I have it saved in my folder for easy reference. Also when you start typing = and the formula name, a little window will pop up with some information to help you.

Genevieve P.

Hi @Kimbersh

Welcome! 🙂

There a number of resources that can help you as you're starting out with Smartsheet, especially with formulas. I would recommend downloading the Formula Template (see here) so you see how the functions work in real-time in your sheets.

There are also some free Webinars on formulas, here: Formulas webinar series

If you have access to it, the Smartsheet University has a number of eLearning tutorial courses as well: https://smartu.smartsheet.com/

And of course, this Community is a great resource, too! There are a few posts on INDEX(MATCH formulas:

=INDEX MATCH .. formula

Index Collect (two criteria or more)

For your questions:

Importing in or uploading a file into Smartsheet will create a New Sheet each time (see: Import Files to Create New Sheets)
However, there is an add-on that your organization may have purchased with Smartsheet called Data Shuttle which can Update a current sheet instead. (Data Shuttle)

In terms of syncing two Smartsheet sheets together, you can either use cross-sheet formulas (like the INDEX(MATCH mentioned above) or Cell Linking, but these would be a one-way sync, with a Source Sheet and a Destination Sheet. (Cell Links: Consolidate or Maintain Consistency of Data)

You may want to look into creating Reports instead (SmartStart: Reporting)

I would highly recommend reviewing the Onboarding Webinars as you get started with Smartsheet.

Cheers!

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.