Sign in to join the conversation:
I want to raise the flag when I have a number in a cell that is >=0 but <4. how do I write a formula that will raise the flag and not include the blanks
I think you want something like this:
=IF(ISBLANK([Column Name]@row), 0, IF(AND([Column Name]@row >= 0, [Column Name]@row < 4), 1, 0))
Make sure the column you put it in is a Flag type, and change Column Name to the column you are analyzing.
Thank you, that was a big help.
You are very appreciated
Since a few days ago, the smartsheet started working differently. I used to write in a cell with dropdown menu the number "5" for example, and would show me the option "5 - built" straight away as first option. Now if I do the same, the first option that appears is "0.5 - waiting", this is really annoying because after…
Hello, I am posting this publicly because my support case has been open since March 11, 2026 without resolution. Case: 09052171 My paid Pro account started failing after the March 2026 Smartsheet login/platform changes. I am currently experiencing: Sheets becoming read-only Newly created sheets disappearing or failing to…
I need to be able to update the values in one cell when another cell has been updated/changed. I do not see an option when selecting "Change cell value in" to be able to have this point to another cell. I have tried putting {{cell reference}} in the dialog box but that just returns the text {{cell reference}} and not the…
