Hi,
I’ve been doing some research and used the AI Generator on the Formula Function on a board but need some help, please.
I am trying to show a status of a line item in a monday.com board based on several status columns combined as follows:
If Research Status Approved Or No Research Required Then Scripting
OR IF
Research Status Approved Or No Research Required
AND Script Status Approved Then Filming
OR IF
Research Status Approved Or No Research Required
AND Script Status Approved
AND Filming Status Complete Then Editing
OR IF
Research Status Approved Or No Research Required
AND Script Status Approved
AND Filming Status Complete
AND Edit Status Complete Then Publishing
OR IF
Research Status Approved Or No Research Required
AND Script Status Approved
AND Filming Status Complete
AND Edit Status Complete
AND Publishing Scheduled Or Published Then Complete
When I put this in the AI Formula Generator it put the below formula for me and the explanation of what the code should do was correct, however, the Status doesn’t update past the “Scripting” Phase even if Scripting is Approved (It doesnt update the Stage to Filming) and of course anything after this stage it also doesn’t update.
Can someone tell me how I can fix this or whats wrong with the below formula? Thanks in advance!
IF(
OR({Research Status} = “Approved”, {Research Status} = “No Research Required”),
“Scripting”,
IF(
AND(
OR({Research Status} = “Approved”, {Research Status} = “No Research Required”),
{Script Status} = “Approved”
),
“Filming”,
IF(
AND(
OR({Research Status} = “Approved”, {Research Status} = “No Research Required”),
{Script Status} = “Approved”,
{Filming Status} = “Complete”
),
“Editing”,
IF(
AND(
OR({Research Status} = “Approved”, {Research Status} = “No Research Required”),
{Script Status} = “Approved”,
{Filming Status} = “Complete”,
{Edit Status} = “Complete”
),
“Publishing”,
IF(
AND(
OR({Research Status} = “Approved”, {Research Status} = “No Research Required”),
{Script Status} = “Approved”,
{Filming Status} = “Complete”,
{Edit Status} = “Complete”,
OR({Publishing Status} = “Scheduled”, {Publishing Status} = “Published”)
),
“Complete”,
“”
)
)
)
)
)