Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 20, 2023 03:11 AM
I need help creating a formula.
Basically I need this to do this:
If there is an extension marked yes than the move-out date changes to how many day per the extend plus the move-out date. Ex if there is an extension original move-out date was 1/1/23 and there was 30 day extend the new date would be 1/31/23.
If there is no extension then move-out date is move-out date. Ex: 1/1/23 is move out no extension then 1/1/23 stays the move-out.
I would think this formula is it but it is not.
Solved! Go to Solution.
Nov 20, 2023 08:53 AM
Hey @ecosystemc,
The reason for not working could one of the following or a combination of them:
- the {Is there an extension} field has "Yes" as option and in formula we added "yes" the text has to match 100%
- the field {number of days} is not a number but a text field, or a lookup field.
- the field {Lease End Date} is not a date field
Could you check with those please and if it doesn't work please share some screenshots of your setting with the fields we use in the formula.
Yours sincerely,
Dimitris Goudis
Nov 20, 2023 08:38 AM
Hey @ecosystemc,
I would recommend to use the following formula where you have to replace the {Number of days} with the field that has the number of days to add.
if ( {Is there an extension}= "yes",
DateAdd( {Lease End Date}, {Number of days},"days"),
{Lease End Date}
)
For any kind of question please do not hesitate to text back.
Yours sincerely,
Dimitris Goudis
Nov 20, 2023 08:47 AM
Date did not change.
Nov 20, 2023 08:53 AM
Hey @ecosystemc,
The reason for not working could one of the following or a combination of them:
- the {Is there an extension} field has "Yes" as option and in formula we added "yes" the text has to match 100%
- the field {number of days} is not a number but a text field, or a lookup field.
- the field {Lease End Date} is not a date field
Could you check with those please and if it doesn't work please share some screenshots of your setting with the fields we use in the formula.
Yours sincerely,
Dimitris Goudis