How to apply conditional formatting on cross sheet reference (dates)?
Can anyone help me with figuring out how to apply conditional formatting to cross sheet references (dates)? I am realizing that even if the column is set up as a date, Smartsheet is not reading the cross sheet reference (these are vlookup and index-match formulas) as a date, and I cannot format. I tried creating a second column, using a join formula and such, but cannot figure this one out. Any help is VERY MUCH appreciated!
Help Article Resources
Check out the Formula Handbook template!