Hello Smartsheet Users,
I have a project I am working on and I need to my calculation to look at two different columns. So here it is I have a column with Employee ID's and a Date Column. I need to a column to show a flag if the employee ID shows up more than once within 30 days. The calculation will look back at the original date for example: Employee 123456 logged in 10/2/2020 and then logged in again 10/15/2020 a Flag will then show up. I need some assistance, please!
Help Article Resources
Check out the Formula Handbook template!