Cross-sheet reference option not appearing in formula editor (Pro plan)

Hi, I’m on the Smartsheet Pro plan. In one sheet I have a column called Status (with dropdown values such as “Building permit received”). In another sheet, I want to count how many rows have a specific status using COUNTIF.

According to the pricing page, cross-sheet references are available on Pro, but when I type =COUNTIF( the “Reference Another Sheet” option does not appear in the formula editor.

Why is the option missing, and how can I enable it?

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141957/cross-sheet-reference-option-not-appearing-in-formula-editor-pro-plan

Hi,

I hope you're well and safe!

Please share some screenshots and/or additional information. (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 day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

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.