ISTEXT(@cell) when cross referencing a sheet

I am new to cross sheet formula's and a formula that works locally on a sheet, I am trying to cross reference so that the data that I successfully found will be on another sheet. Here is the formula that I used on the local sheet
=COUNTIFS([Rep Completion Confirmation]:[Rep Completion Confirmation], "", VIN:VIN, ISTEXT(@cell))
when cross referencing I am not sure how to add the ISTEXT(@cell) portion.
Β
Any help would be much appreciated!
Comments
-
I haven't found a way to do that - Pretty sure it's not possible at the moment to perform any math or logic on a cross-referenced cell in a formula.Β Β
One work-around - Create a new column in the target (local) sheet, and call it "IsText" (or whatever you want). Set it as a checkbox, with the formula of "ISTEXT(VIN@Cell)".Β
Then you can go back to the COUNTIFS, and instead of calculating if it's text inside of the countifs, just countifs the isText column if it's true. Should get the same result (and you can hide the isText column so it's not in the way).Β
Β
Β
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!