Formula through API
I'd like to make a kinda tricky formula write with the API. I don't know if it is possible but I guess it is. I just have no idea how to properly do it. Could someone land a hand on this one ? Here's the case:
I'm going to add rows in the sheet, each of them has two date type fields I'm interested in. I want the first column (which is the flag for 'At Risk') to be True if the first date (Column 5) is higher than the second (Column6). As the second date isn't filled every time, I don't want the condition to trigger if the second date field is empty.
Do you see a way to do this ?
Thank you !!