Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Reminder for every month task
Hi,
Every month, we also help our client (around 1000 ) to prepare monthly financial reports and upload their web site. Some of them has specific date required to upload.
In SS, we have total 4 sheets. Each sheets represent 3 month(we can't put 4 sheets into one because limitation of SS:, maximum 5000 rows) . We have one column "specific date". E.g., that client request each month 10th to upload, we put 10 in the column.
We can't set reminder for that because it does not include the month in column .
I have very time consuming way to do is manually change the information in column from date to Month and Date. E.g., I manually change 10 to Sep 10. Is there other way to do?
By the way, does SS has formula like as Current month? I know it has today() but do not see any current month formula
Thanks
Comments
-
Peter this is feasible. I would approach it like this:
- Create a cell (text/num type) for your day in your case the cell value would equal 10
- Calculate your reminder date make sure the cell is of the date column type:
- =DATE(YEAR(TODAY()), MONTH(TODAY()), daycell)
The formula above will give you the day you designate with today's month and year. Set a reminder on the calculated date.
-
Sorry for late reply. The formula is perfect. However, we have another similar issue. Somehow, some client request to receive the financial reports specific date (which is e.g., first Monday of the month)
I can't use formula that you mention:
=date(year(today()),month(today()),daycell)
I know outlook calendar has similar function for this reminder . Does smartsheet have similar one?
E.g., if the client request the report upload on 3rd week Monday, then I can set up the reminder 2 days ago to get alert.
Please help.
Thanks
-
Have you tried the Send Update Request feature? That should do the trick. You can set separate request for each row.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives