Sign in to join the conversation:
I want to set up a reminder to occur 6 weeks prior to an event. The pull down menu choices of timing give me a maximum of 4 weeks or 30 or 60 days? How do I schedule it 6 weeks or 42 days prior to the event?
Thanks!
Hi,
You'd need a so-called helper column that for example, would have the formula to calculate the date or check a box if it's 6 weeks prior to the event date.
Would that work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
JH
Just base your alerts on a second date column that adds a number of days, eg 30/46/60 to the actual date.
RichardR
Hi Smartsheet, What's the current max-cell-count for grid view? Is there an easy way to identify where the sheet is at for cell count? I've asked AI a few times, ways. It's a little confused today. Also did a few count( formulas, but Excel seemed to produce a better assessment. 🤨 Thx, Eric
Hello, I have a form for our team to complete each week to obtain a pulse check. I am trying to tally the responses from the team to show in a table on the dashboard, however, I cannot get it to display how I would like for it to. I want the horizontal axis to show the categories (columns) and for the vertical axis to be…
This discussion was created from comments split from: Change Permissions for Specific Items in Workspace.
