Hi there,
I just need a little help to finish my workflow !
I want to put a status from the automatic field “Last modified time”.
Formula is : IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 13, “ :exclamation: ”, IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 7, " :alarm_clock: ", IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 1, “ :repeat: ”, IF(IS_SAME(TODAY(), {Update URL}), “New :rocket: ”)))))
It works pretty fine when the field is “date” but won’t work when field is modified in “Last modified time”.
Anyone can help please ?