Trending in Smartsheet Basics
-
MAX COLLECT for dates in a row
I have a certification that requires a few lessons to be fully certified. Each lesson has a completion date in it's own column and a date column for when they become fully certified. So, if there if one training is missing a completion date they are not considered fully certified. My need is to be able to collect the max…
-
PDF Icon / Thumbnail in the row?
Hi, I'm sure its a big use of smart sheet, I use various registers to store documents especially drawings. Each row is a drawing or document, if there are different Issues I use the upload new version. There are the Ref#, Issue#, description and drawn date columns etc. The drawing is a pdf attachment. However you can not…
-
If date range includes a Friday - check a box
I have a sheet with a start date and an end date. I would like a checkbox column to be checked if that date range includes a Friday. Any ideas on how I would do that? Thank you in advance. Jennifer