I have a list of dates with a y/n column.
I want to check the date in this row with another sheet that has a list of dates.
One one sheet, I have a travel log of dates.
Second sheet, I have my statement of dates that I used the toll.
I want to flag the dates I use toll on that travel log sheet. I'm not sure how to compare a date to a list of dates.
Can somebody help?
Solved! Go to Solution.
So this works but in order for it to compute, I have to open each one, edit, and save. I don't need to change anything but it won't calculate an existing set of data. It will probably update new data. Is there another way where I can run this expression on a list already?
Virtual columns recalculate instantly, while real columns only calculate on a sync, since they have to write the data to the source. Because of this virtual columns are actually more expensive data crunching wise, but are useful in certain scenarios. (At least this is my understanding - someone here with more technical knowledge could provide a more thorough explanation). I am glad you got it working!
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |