Sign in to join the conversation:
Hi,
I was wondering if there is a way to embed/link an image to present itself in the cell if that cell was to presented as 'true'. I want to be able to tick a checkbox and for the 'true' value to present an image.
Thank you.
Hi Harry,
Unfortunately, as far as I know, it's not possible today.
Please submit an Enhancement Request when you have a moment.
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
That's not something that can be done directly through Smartsheet. You may have to look into a 3rd party tool.
I thought this would be the case! Don't worry ill submit an enhancement request.
Cheers anyways guys
I assume you want the image to go away again if unchecked. Is that true?
Can you describe your use case?
Craig
Yes that is excalty what I want.
So basically I have 3 options for a Keypad (for lighting). Each one is different being 1 Gang, 3 Gang and 6 Gang.
I want the selected Keypad to display a image of that keypad as we are wanting to build a testing schedule with images for each room.
So for whatever device is selected across the spreadsheet it will display images. Which evidently the images will get linked to a master template on google docs using Smartsheet merge.
I hope that wasn't all confusing!
Cheers, Harry
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…