Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Extremely new user asking for mercy with IF Blank and such

Topic Labels: Formulas
Solved
Jump to Solution
1867 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Rodolfo_Torres
5 - Automation Enthusiast
5 - Automation Enthusiast

I am comfortable creating and linking bases, but I really need help inside my grid view for 1 item, I just need to understand how to create a formula that will auto-populate if one of my users has been assigned an item, this formula column should have 4 different selections either checked-out, available, damaged or lost. Could someone please help me?

PS, I have been using the Filter options and another view meanwhile to display what I need, but I need this to not be having to change my database to check-out or damaged after every new user assignment.

1 Solution

Accepted Solutions

If you want a formula, this would work, but then you can’t select another option manually:

IF({Staff Last First}=BLANK(),"available","checked-out")

If you want the option to manually select or overwrite the options, you should go for an automation (paid version).

See Solution in Thread

5 Replies 5
Databaser
12 - Earth
12 - Earth

Hi @Rodolfo_Torres.

one of these options based on what trigger?

My apologies, just 2 selections, checked out and available.
The trigger should be just by adding a linked user name from my other Staff view/sheet.

I guess I can always manually change the status to Damaged or lost if needed.

I would like for Status to change itself to checked-out Capture once I add a staff name in my list. And change back to Available when empty.

If you want a formula, this would work, but then you can’t select another option manually:

IF({Staff Last First}=BLANK(),"available","checked-out")

If you want the option to manually select or overwrite the options, you should go for an automation (paid version).

Thank you, that worked for me.