I have 4 columns one with actual ticket received date, 1 with current date and 1 with physical doc received date and last one the mode of ticket.
If the mode reads “Physical” the output should be current date minus the physical received date
If the mode reads “Scan” the output should be current date minus the actual ticket received date.
How to apply the formula so that I do not have to manually input every day or twice a day to generate a report
Thanks in advance