Gallery view - possible to "disable" one image?

How does one user from one county receive data different from a user in another county?

If I’m in County A - you’d want me to see Count A’s information. How is that happening in the app right now?

I’m not sure I understand your question. This has been created just for our county.

I added an “activated” column and changed the action from just [Item]=Form to AND([Item]=Form, [Activated]=Yes) and this prevents the form from opening.

How would I swap out the images though?

You could create an additional column that holds the greyed out image - then another that switches between the two depending on the status - and use that as the label for the table.

I think the reason for the “user in county” question is an attempt to understand how activation works.

I’ve been thinking about how this might work in your app and will venture a guess. Tell me how close I am!!

  1. A state of emergency is declared and the decision is made to use Evac Centers.
  2. You would “Activate” the Evac Centers in the app and this enables “Form”
  3. However, while there may be say 20 Evac Centers. Initially only 10 open and others stay closed until needed.
  4. A user opens the Form to fill out needed information, a part of which is selecting the appropriate open Evac Center.
  5. As Evac Centers become Full, others may open to take on overflow.
  6. As emergency needs decline and wind down, Centers return to a Closed state.
  7. Once all centers have closed, emergency is over, the app is “de-activated” and the Form becomes disabled.

So…how close was I???

Very close. Post Hurricane Irma the decision was made we open all for an incident instead of a tiered approached but you outlined it well.


I’ve never attempted a “switch” before. I’ll try it.

It doesn’t seem Smartsheet works well with 2 image attachments in the same row. I tried to add another column as mentioned but it essentially made the app unrunnable.

Here is where I’ve ended up. Clicking “no” or “pre reg form” doesn’t do anything but take users to home page. Would be nice to have a gray image but I may not be able to make that happen.

1 Like

I’ve never even heard of Smartsheet before joining this community, so I can’t help in that realm. But in Excel, I use relative image paths of “/Images/ImageName.png”. Doing that allows me to also do things like:
CONCATENATE("/Images/", [ColumnOfSomeSort],".png")

If you can also use relative pathways instead of direct attachments to the sheet, this may be easier than any other way.

1 Like

Do you store your images in the cloud in order to use them?

Yeah. I use an Excel sheet on OneDrive.

File Name Value

If you store the value as a file name, the image or document must be stored in your cloud file system, not on your own computer!

  • In the app editor, we provide a file selector widget that lets you browse your cloud file system to find an image.
  • If you are specifying an image or document file name in your spreadsheet, the file should be in the same folder location as your spreadsheet. For example, if you use Google Drive and your spreadsheet is in the /appsheet/data/MyApp folder, then if you have the image MyImage.jpg in the same folder, you can just use the value, MyImage.jpg , in the appropriate cell.
  • It is sometimes easier to organize images in their own folder. For that reason, we allow image file names to be specified relative to the location of the spreadsheet. For example, if your images are in a subfolder called Images , you can use the cell value, Images/MyImage.jpg or ./Images/MyImage.jpg .

How were you able to display and text in this arrangement?