Haven’t tested it so there could be errors, but you basically need to nest IF blocks. The indented version is just for readability. Run the minified one below it to debug.
Indented for Readability
IF(
AND({text input},{image}),
"
Ready to go",
IF(
{text input},
“
upload image”},
IF(
{image}),
"
write text",
IF( DATETIME_DIFF({deadline},Today(), 'days') < 2,
“
HURRY”,
"
write text, upload image"
)
)
)
)
Minified
IF(AND({text input},{image}),"
Ready to go",IF({text input},“
upload image”},IF({image}),"
write text",IF( DATETIME_DIFF({deadline},Today(), ‘days’) < 2,“
HURRY”,"
write text, upload image"))))
Thank you Zollie,
With your input I was able to make it work. Unfortunatly I also realised that adding the {deadline} field into the formula actually didn’t improve the “clear overview” I had in mind… Instead I think it’s better to separate them and make an additional field that goes like this:
If {deadline} is within 2 days, and status is not "
Ready to go" Then “
Hurry” , “ :thumbs_up: on scedule”
I tried using your previous reply as an example but for some reason it doesn’t recognise the difference between days. Could this be because the {deadline} field is also a formula field instead of an actual date field? It shouldn’t be tho… I made a calender view based on the same {deadline} field… So it should recognise it…
Any ideas?
Thank you Zollie,
With your input I was able to make it work. Unfortunatly I also realised that adding the {deadline} field into the formula actually didn’t improve the “clear overview” I had in mind… Instead I think it’s better to separate them and make an additional field that goes like this:
If {deadline} is within 2 days, and status is not "
Ready to go" Then “
Hurry” , “ :thumbs_up: on scedule”
I tried using your previous reply as an example but for some reason it doesn’t recognise the difference between days. Could this be because the {deadline} field is also a formula field instead of an actual date field? It shouldn’t be tho… I made a calender view based on the same {deadline} field… So it should recognise it…
Any ideas?
IF(
AND(
DATETIME_DIFF({deadline},Today(), 'days') < 2,
{status} != "
Ready to go"
),
“
Hurry”,
“
on schedule”
)
IF(
AND(
DATETIME_DIFF({deadline},Today(), 'days') < 2,
{status} != "
Ready to go"
),
“
Hurry”,
“
on schedule”
)
You’re the best!
I tried to copy the formula directly. Unfortunatly that didn’t work… When I tried it manually, it did the job.
Very nice!