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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 306 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!