I have the formula below to give us a due date for items, BUT when the item is due I would like to add an emoji OR change the field highlight color. Can anyone help me figure out what I need to add to this formula in order to make this happen??
DATEA...
Aloha!
We would like to have our dated fields have a formula for expiration date and for the color or something to change so it is obvious when things expire.
Does anyone know how to do this?
Thank you for your response :slightly_smiling_face:
I have a screen shot to show you what I tried based on your feedback…
And here is my formula:
IF(IS_SAME({2-Step TB EXP}, TODAY()), “ :x: ”) & DATETIME_FORMAT({2-Step TB EXP}, “L”)
It will allow m...
I must be so dense when it comes to this. I copied and pasted the formulas you sent me but airtable said “invalid formula”. Do you know what I am doing wrong? Is there someone that I can speak with for a couple of minutes to help me with this? Sorry ...
Can you help me? I am sorry to ask again… I understand what you are saying and that is exactly what I would like to do!
I would like the column to change color 1 month prior to the expiration date noted in the field. Are you able to help me and send ...
