A date row which can subtract from a date column
I want to do something like this where I want to give weights to projects for particular month based on how far the release
date is . I dont think i can make a row a “date row”. How can I achieve this?
Best Answer
-
Hi @dbalakk
You have to convert the 36 months to days (which in your case would be 1096) and put the weights in double quotes "value", this is how your formula would work -
Hope this helps,
Cheers!
Ipshita
Ipshita Mukherjee
Answers
-
Hi @dbalakk
You have to convert the 36 months to days (which in your case would be 1096) and put the weights in double quotes "value", this is how your formula would work -
Hope this helps,
Cheers!
Ipshita
Ipshita Mukherjee
-
Thank you so much! Yes it does
-
@dbalakk - I am glad it helps you, don't forget to hit the "Awesome" to my response if it helped you :)
Cheers!
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!