How would you write a date time formula for Beginning of current month to End of current month? The trick is, it’s the current month and the month always changes.
Any Jedi out there?
How would you write a date time formula for Beginning of current month to End of current month? The trick is, it’s the current month and the month always changes.
Any Jedi out there?
Hi,
Need some help with this If statement. Currently: IF({Payment}=“Outside Finance”,CREATED_TIME())
What I would like to do is " If ({Payment}=“Outside Finance”,Create-Time(), And if when {Payment} changed from “Outside Finance” to “something else”, leave the original time created.
Thanks for your help in advance!
This should be its own post.
Assuming your {Payment}
field shows sequential steps in a process your formula could be IF(OR({Payment}='Outside Finance', {Payment}='whatever comes after outside finance',{Payment}='etc'),CREATED_TIME())
Hi,
Need some help with this If statement. Currently: IF({Payment}=“Outside Finance”,CREATED_TIME())
What I would like to do is " If ({Payment}=“Outside Finance”,Create-Time(), And if when {Payment} changed from “Outside Finance” to “something else”, leave the original time created.
Thanks for your help in advance!
Unfortunately formulas don’t work that way. There’s no way to tell a formula to “freeze” on a certain value once a condition is met. It will always evaluate based on whatever triggers feed it, so if any related field changes, it’s gonna change.
If the suggestion from @Kamille_Parks won’t work, the only other way to do this is to tie in a service like Zapier or Integromat, and change {Outside Finance}
from a formula to a date field, letting the integration service populate the field with the proper date based on the rules you set.
Thanks for your reply. I have found a work around where I changed the field to a multi-select and this will record the initial status and also what changes after, thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.