Can a workflow on one sheet update specific empty cells on another sheet?

Glenn Meyer

I have a sheet with a list of no longer needed items that may be useful to another group. I have setup a custom URL (custom per row/item using a unique asset number) that opens a form on a second sheet to gather the requestor's contact information. When that new row is created on the second sheet, can a workflow change/update an availability status on the original list of items available so that when the first request is made the item status changes to unavailable so duplicate requests don't happen?

Genevieve P.

Hi @Glenn Meyer

Yes! You can use a formula to check the second sheet and see if that current row's unique number is present on the second sheet. If it is, you can display "Unavailable", but if the formula can't find any rows that have this unique number, it can display "Available".

Try something like this:

=IF(COUNTIF({Unique Number Second Sheet}, [Unique Number]@row) >= 1, "Unavailable", "Available")

Let me know if this is what you were looking to do.

Cheers,

Genevieve

Glenn Meyer

This is perfect!! I was able to make it work. Thank you!!

Genevieve P.

Hi @Glenn Meyer

Yes! You can use a formula to check the second sheet and see if that current row's unique number is present on the second sheet. If it is, you can display "Unavailable", but if the formula can't find any rows that have this unique number, it can display "Available".

Try something like this:

=IF(COUNTIF({Unique Number Second Sheet}, [Unique Number]@row) >= 1, "Unavailable", "Available")

Let me know if this is what you were looking to do.

Cheers,

Genevieve

Glenn Meyer

This is perfect!! I was able to make it work. Thank you!!

Genevieve P.

No problem at all! I'm glad I could help. 🙂