Hi Hannah,
you use the following if formula:
if(status=“Completed”,LAST_MODIFIED_TIME(status),“leave it blank”)
Hi Hannah,
you use the following if formula:
if(status=“Completed”,LAST_MODIFIED_TIME(status),“leave it blank”)
Hi Dimitris! Thank you! I tried creating the field, but it returns an error like so:

Can you see what I’m missing?
This is the field I’m pulling from:

Hi Hannah,
most probably something is wrong in other fields. In order to understand where exactly the problem occurs, please follow the following steps:
- Create a formula field with following function:
if(status =“complete”, 1,0) → if this works then the status value checker works perfectly
- Create a formula field with following function:
Last_modified_time(status) → if this works perfectly then the last_modified_time() function works perfectly.
Then try to combine the 2 functions in one, if it doesn’t work please check the text on your functions, all characters you use have to be english and not in other language. An other common issues is some workspace or base settings and we can check them after that trial.
Hi Hannah,
most probably something is wrong in other fields. In order to understand where exactly the problem occurs, please follow the following steps:
- Create a formula field with following function:
if(status =“complete”, 1,0) → if this works then the status value checker works perfectly
- Create a formula field with following function:
Last_modified_time(status) → if this works perfectly then the last_modified_time() function works perfectly.
Then try to combine the 2 functions in one, if it doesn’t work please check the text on your functions, all characters you use have to be english and not in other language. An other common issues is some workspace or base settings and we can check them after that trial.
Thanks for helping me troubleshoot
all seems to be working now.
Weirdly this formula throws an error:
IF(Status=“Complete”,LAST_MODIFIED_TIME(Status),“leave it blank”)
And this one doesn’t:
IF(Status=“Complete”,LAST_MODIFIED_TIME(Status),“leave it blank”)
Unless I’m blind, they both look exactly the same to me :grinning_face_with_sweat:
Thanks for helping me troubleshoot
all seems to be working now.
Weirdly this formula throws an error:
IF(Status=“Complete”,LAST_MODIFIED_TIME(Status),“leave it blank”)
And this one doesn’t:
IF(Status=“Complete”,LAST_MODIFIED_TIME(Status),“leave it blank”)
Unless I’m blind, they both look exactly the same to me :grinning_face_with_sweat:
Lol I can’t give an explanation