Formula Support

Support
1

Hi There,

I’m trying to add a formula into a form which would show me the age of a logged issue.

For example, I would inset the date that the issue was logged, I would then want the next column to show me how many days old that issue is based on today’s date.

I’d usually use the formula “=today()-Cell Reference” when doing that it formats the result as a date and not a value.

Any support would be appreciated.

2

Hi,

You’ll need to change the field type to the “Numeric” so that it will return a numeric value.

Besides, our formula works case sensitive. Hence, please replace the today() by TODAY().