Sign in to join the conversation:
I would like to use the direction symbol (up,down,sideways) in a formula if =IF([ISS-Backlog]1 < [ISS-Backlog]2,“Down”) but it is not working. Any help would be greatly appreciated
Hi,
It should work. What error message are you seeing?
=IF([ISS-Backlog]1 < [ISS-Backlog]2; "Down")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
I hope this helps you!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Problem: I want to calculate the number of days past the End Date or the number of days until the end date. If the End date is less than today, it would be "Overdue by " X days and if the End Date is greater than todays date, it would be "Days to Complete ". If the Status is Not Started or Completed, then leave the field…
I have a sheet with a list of non-distinct master ID numbers that are grouped into "Group 1" through "Group 6" based on a distinct secondary ID. I am trying to write a formula to grab the greatest priority value if there are differences within the same master ID. My formula is in the correct priority order. Here is what I…
