I have a few questions

Rui Goncalves

Hi,

I would like to know if/how to:

1. Create a rule to automatically hide rows based on a certain condition
2. Set conditional formatting on "card view". Ex.: Hide a card or highlight it with a different color based on a certain condition
3. Lock columns from being moved around without preventing users from editing their content.

Thank you.

Bassam Khalil

Hi @Rui Goncalves

Hope you are fine:

1- you can't  hide rows based on a certain condition but you can ( lock/unlock Row & copy and move the row to a different sheet) please read the following article to understand how Automation

2- please read the following article to understand conditional formatting

3- please read the following article to understand Sharing Permission Levels