Set up reminder for the first of the month for all inventory items needing calibration that month
I have a Smartsheet that has an inventory of equipment. I would like to be reminded when this equipment needs to be calibrated. The calibration dates are not always on the 1st, but I would like my reminder to be sent out on the 1st of the month for all items that need to be calibrated in that month.
I tried creating a new column and used the MONTH formula to change the full date into the number of the month only, which worked "11-Mar-22" in the calibration date column was listed as "5" in the new column I created. But I was not able to set up a reminder to trigger when the date is reached because it is a number and not a date.
How do I set up this reminder for the first of the month for all inventory items that need to be calibrated within that entire month?
Help Article Resources
Check out the Formula Handbook template!