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
@Rhonda Keller, SmartU How many times are users allowed to attempt the quizzes at the end of the self paced core path courses? I have had a few people at my company reach out to me stating that they are unable to retake the quizzes.
Have a samples request sheet that is populated by sales via a form. Once the shipment has been completed (triggered by date and tracking number input), the row is moved to an archive file and locked. Sales would like the ability to 'copy' previously archived rows, change dates (as well as automatically change the status,…
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
