Is it possible to filter modified column to look at only certain columns?


Hi, I have a sheet that contains a list of items with 7 columns. I've created a dashboard and on it I'd like to highlight only those rows that have changed. I know there is the modified column but I only want to highlight a row as changed if something was updated in 4 of the 7 columns (e.g. I add a new column and now every row says it's updated but really the information I care about has not). Any recommendations on how to accomplish this? Does Smartsheet allow me to build a query looking at specific columns to see if a modification has occurred within a certain time frame?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!