priority number or letter

**jmtisme** · 08-03-2014, 12:42 AM

I am trying to build a sheet showing the priority of each job. The priority is to be set by an upcoming date.I have tried to use the IF function but to be honest it lost me.I am probably you guys worst nightmare as I am one of those self taught guys. Any help would be great. I also looked at a macro but don't think we can use Marcos on our company system as it appears disabled.

**FDibbins** · 08-03-2014, 01:00 AM

Hi and welcome to the forum

I am self-taught as well (and learned most of the advanced stuff I know from this forum), so no nightmare here

Having said that, I think it would help if you could upload a small workbook, showing samples of what you have, and a few examples of what you expect.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**jmtisme** · 08-03-2014, 03:10 AM

Will do asap on my tablet just now only have numbers at home so.I will try using that

**jmtisme** · 08-03-2014, 03:26 AM

Thank you for the welcome. I have added a file but it is in Numbers. The first column will have the formula to show the priority 1 to 5 or Ato E This will be set by the entry date in the next column the date nearest to todays date will determine the highest priority