Which gives me different values depending on how much time is left in the “Due” column. I’m trying to add another variable that says that if checkbox column “Done” is ticked, disregard all the above formula and return value “Complete”. How can I go about doing this please?
Oh nice, you just taught me something there! Thank you! :slightly_smiling_face: I actually thought it would evaluate the word “checked”, which is the text data that it is actually typing into the field!