=(thisRow.[Date of Last Made Tool] +days(thisRow.[Average Tool Lifetime in days]))
What operator should I use to get this to spit out a date?
For example of what I am looking for, 5/4/2023 + 7 days should be 5/11/2023 .
=(thisRow.[Date of Last Made Tool] +days(thisRow.[Average Tool Lifetime in days]))
What operator should I use to get this to spit out a date?
For example of what I am looking for, 5/4/2023 + 7 days should be 5/11/2023 .
Hi @Ryan_Lacey !
What is your formula currently returning ?
I mean, what does the result looks like ?
So I may have not been clear. I have three columns: Date Made (date format), Lifetime (number format), and Estimated Next Due Date (date format). I want the third column to automatically calculate based on inputs in the first two columns. Right now I have to manually tell the program to apply to blank rows and it works. I want it to do everything automatically, especially in the case of changing lifetimes as we improve our process.
Ah! So I guess you’ve used this formula into the Value for new rows
…
Just under the Value for new rows
there’s a Add Formula
.
If you click on it, it will open the formula editor and this is where your formula should be going … but without the =
as a starting point.
This should be sufficient
thisRow.[Date of Last Made Tool]
+ days(thisRow.[Average Tool Lifetime in days])
It might return an error if your 2 other fields don’t have a value yet though
This works! Thank you so much!
My pleasure @Ryan_Lacey !
Glad to know this now works as expected !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.