I don't know if this is possible. I have a column that calculates number of days based on an date of expiration column. For example, a contract is ending on July 1 2018 and today is June 1 2018, the column should then display 30 days. I have been trying to make an email alert based on the number of days, 30, 60, 90.
I have tried using Calculated Value in Choice Field, but it doesn't recognize other fields outside of its own. I have also tried using Calculated Field, but Three-state Workflow doesn't recognize other fields apart from Choice Field.
I don't have access to other workflow and designer so... any suggestions?