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
This discussion was created from comments split from: Plan Asset Manager - will it capture orphaned assets already in the system?.
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…
