Lookup - if - and?



We have a basic sheet using a form, users scan the items QR code, drop their location and select if checking in or out an asset (tick box) and nominate it's return date. Currently we have 100+ assets on the sheet.

I would like the sheet to alert the Proj Manager when the item has not been returned by the due date.

Problem - When using the form sheet sees it as a new entry, there is no way for the sheet to know if it was checked out in the first place or vice versa. I'm sure there's a formula here buggered if I know it though - cheers all.


Forever forwards Backwards never.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!