Email - Spreedsheet

[LETICIAHELENA]

Hello,

I need send an email separate just by the priority, but the text that I wrote repeat beetween the sprredsheet, How Can I exclude 1 text just to keep the first email text?

[alexnajm]

@LETICIAHELENA yes it's possible with a multi row formula tool - however, you would need to make sure to think through the logic to fill in those values. For example, should the null value in "data prevista" be 2023-04-04 or 2023-04-05?

[LETICIAHELENA]

it' necessary be the same date just the copy of the other column, if null is in the columns data prevista than need copy from data conclusão and vice versa. How can I wrote the formula  in teh tool?

[alexnajm · Accepted solution]

@LETICIAHELENA the Formula would look something like IF [data conclusão] = null() THEN [data prevista] ELSEIF [data prevista] = null() THEN [data conclusão] ELSE null() ENDIF