Skip to main content

I would like the formula to be able to identify the client by field {Rodzaj usługi}. If the client would be (in the {Rodzaj usługi}) “Fotografia ślubna” then I would like {Status} to show “ ✔ ” only if the {Odbitki}, {Album}, {Galeria internetowa}, {Selekcja zdjęć}, {Zwiastun}, {Obróbka zdjęć} fields will be filled with the word “Oddane”. Otherwise, the {Status} field should show “ ❌ ". When the client would be (in the {Rodzaj usługi}) “Film ślubny” then I would like {Status} to show “ ✔ ” only if the {Film wrzucony na dysk}, {Teledysk ślubny}, fields will be filled with the word “Oddane”. Otherwise, the {Status} field should show “ ❌ ”.


This formula works for two {Rodzaj usługi}. I would like to add one more “Service Type” on the same terms as the previous ones.


Namely, “Ślub cywilny”


If the client would be (in the {Rodzaj usługi}) “Ślub cywilny” then I would like {Status} to show “ ✔ ” only if the {Galeria internetowa}, {Selekcja zdjęć}, {ZWIASTUN}, {Obróbka zdjęć} fields will be filled with the word “Oddane”. Otherwise, the {Status} field should show “ ❌ ”.



Hi Bartek, try this out:


IF(

	AND(

		{Rodzaj usługi} = "Fotografia ślubna",

		{Odbitki} = "Oddane",

		{Album} = "Oddane",

		{Galeria internetowa} = "Oddane",

		{Selekcja zdjęć} = "Oddane",

		{ZWIASTUN} = "Oddane",

		{Obróbka zdjęć} = "Oddane"

	),

	"✓",

	IF(

		AND(

			{Rodzaj usługi} = "Film ślubny",

			{Film wrzucony na dysk} = "Oddane",

			{Teledysk ślubny} = "Oddane"

		),

		"✓",

		IF(

			AND(

				{Rodzaj usługi} = "Ślub cywilny",

				{Galeria internetowa} = "Oddane",

				{Selekcja zdjęć} = "Oddane",

				{ZWIASTUN} = "Oddane",

				{Obróbka zdjęć} = "Oddane"

			),

			"✓",

			"×"

		)

	)

)

It works perfectly, thank you!

It works perfectly, thank you!


I’m glad I was able to help!

Reply


Terms & Conditions