If formula for recurring date
Comments
-
Hi,
Try something like this.
=IF([Vendor Name]@row = "x"; DATE(YEAR(TODAY()); MONTH(TODAY()); 15))
The same version but with the below changes for your and others convenience.
=IF([Vendor Name]@row = "x", DATE(YEAR(TODAY()), MONTH(TODAY()), 15))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hej Andree!
This defintely gets me closer to what I need. Could you please provide the formula to add multiple options for various vendors? I can change 15 to something else, but my normal +IF for other vendor options is not working right.
Also, is it possible to have the next relevant date? Right now it chooses Sept 15, already pass, instead of upcoming Oct 15.
Thank you so much for your help!!!
Iris
-
You would need nested IF statements to determine the proper 15th to display.
As far as having multiple variations for different vendors... How many different variations would you have and what would they be?
-
Did you get it working or do you still need help?
Have a fantastic week!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives