Sign in to join the conversation:
I have tried searching and figuring out what my formula should be, but I just can't get it. I want my flag to be red when there are 3 days or less to due date. Frustrated. See screenshot.
Try something like this...
=IF(TODAY(3) >= [Due Date]@row, 1)
To get it to ignore the flag once the row has been checked as complete, you would use this...
=IF(AND(Complete@row = 0, TODAY(3) >= [Due Date]@row), 1)
That works perfectly! Thank you so very much!
Happy to help!
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
