I’m looking for some help with a formula that…
calculates the difference between the number of days since a record was created and a field has initially had content entered into it.
–> 1a) If field is blank, it would calculate the number days betwee...
Thank you again, W_Vann_Hall. So, here’s the last challenge which is a function of combining your code suggestions:
Intended behavior:
If watched_field is empty, put in “0” immediately
If watched_field has been empty for more than 1 day since record ...
While you’re my guardian angel, let me ask you this…
IF(Watched Field1 = “”,“ :red_circle: ”,“ :yellow_heart: ”) unless WatchedField2 and WatchedField3 and WatchedField4 have data in them, in which case, “ :green_heart: ”
Does that make sense?
Thanks very much for taking the time to respond. Unfortunately, there are many other fields that are entered manually so I think the zap would be firing a lot when it’s not relevant.
How about…
If {Watched Field} is empty, calculate and post the diff...
