Bwoods113✭✭

@Genevieve P. Thank you this is exactly what I needed.

@Allegra Silcox Can the card view be utilized when a report is added to a dashboard?

@Paul Newcome I want to bring in the information from range 1 if the information in range 2 is not equal to 0. Do I have my formula set up backwards? Thank you for your help.

Thank you so much that was it, it works perfect. I appreciate your time and knowledge. Brandon

Thank you so much I understand the formula but I think I may have a sytax error, would you mind looking to see if you can find it? I cant seem to locate it. =DATE(VALUE(MID([Last Started]@row, FIND(" ", [Last Started]@row, FIND(" ", [Last Started]@row) + 1) + 1, 4)), =IF(LEFT([Last Started]@row, 3) = "Jan", 1,…

As I was creating screenshots I think I figured it out. When I leave in some of the test data, they copy over fine. I went through and blanked out all the cells in an effort to make a clean slate for the template (this is the problem). I input numbers into all the cells that have references and the references copy over…

It is a folder I am saving as new, in my project tracking workspace. I am losing some formulas on some other sheets too. I cant find a pattern to it I am just losing data when I do the save as new.

@Genevieve P. Thank you so much I appreciate all your help.

@Genevieve p .我需要相同的formula I have looked at it for 15 min now and I cant figure out what I have wrong, would you mind looking to see if I have a syntax error in this? =INDEX(COLLECT({Cert Import Temp Range 1}, {Cert Import Temp Range 2}, CONTAINS([Primary Column]@row)), 1)

I plugged it in this way: =INDEX(COLLECT({Work Order Range 1}, {Work Order Range 1}, @cell <> ""), COUNTIFS({Work Order Range 1}, @cell <> "")) This returns the 645 can I use this same formula in another cell to pull in the next number when it is added?