Checkmark's
Hello,
so this might be a strange one but doing this to run automation. i have the Bolo column set to check others sheets for serial numbers. i created a remove bolo column to search the Bolo Column and to find any Checkmarks. then wanting it to set a checkmark in the remove bolo column that has a checkmark in the BOLO. what would be the best formula for this? im just getting checkmarks even the one ones that have no checkmark in the Bolo column. im doing this cause i will be setting up automations
Answers
-
Hi @BryanOramas ,
So you want Remove Bolo to match the Bolo column? You could just use =[Bolo@row].Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing?
Grab time on my calendar here:
https://calendly.com/sam-samharwart/30min -
how would that formula look like?
-
nevermind i figured it out lol. thank you
-
So sorry i think i know what i want this sheet to do. i want remove Bolo to match checkmarks on another sheet. so far i only have the begin part of the formula.
-
You could do a lookup using Index(MATCH()) if both sheets have a unique value on each row (such as serial number). I'd need to see more of the columns to know if that's the right approach.
Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing?
Grab time on my calendar here:
https://calendly.com/sam-samharwart/30min -
So the row would have a unique value like a serial number
-
Ok - you could use an index/match to grab the check boxes then for your Remove Bolo column.
=INDEX({Device Returned}, MATCH([Serial]@row, {Serial Asset}, 0)){Device Returned} would be a cross-sheet reference to the Device Returned column
{Serial Asset} would be a cross-sheet reference to the Serial Asset column.
[Serial]@row is a reference to the Serial column on the main sheet.
Let me know if that works for you!Thanks,
Sam
—
Want to chat about a Smartsheet problem you're facing?
Grab time on my calendar here:
https://calendly.com/sam-samharwart/30min
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!