auto tick mark with nested if formula

[jimmiboy]

Hello Everybody,

I have two sheets, one DailyCard where I update the daily details received from the blocks, second sheet, Tracking is for check whether received or not. I wish Tracking sheet should automaticaly update the stuatus whether details received or not. if Total in DaliyCard = < 0 then details received else not giving signs in Tracking sheet ( as shown)

thankx

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[jimmiboy]

Ali,

pl guide what shd be the correct title for help in Nested If forumla

[AliGW]

A statement telling us what you want to achieve with the nested IF - maybe one from your opening post?

I am not going to do this for you.

[AliGW]

What does this have to do with tick marks? There is nothing in your opening post or sample workbook about tick marks. Come on, Jimmiboy - you've been a member long enough now to see what good thread titles look like!

Use something like this: "Tracking sheet to automaticaly update the stuatus whether details received or not".

In future, think more carefully about your titles: you have been warned three times about this already.

Here's one way:

=SUMPRODUCT(G6:I6,$G$5:$I$5)

[jimmiboy]

i think u didnt understand the the query properly, my query is simple if "toal colomn" of DailCard sheet is empty then tracking sheet date clomn will be "X" else "✔" see the attachment it will help to understand

[Bo_Ry]

Please try
=IF(SUMIFS(DailCard!$J$6:$J$17,DailCard!$F$6:$F$17,$H9,DailCard!$E$6:$E$17,I$8),"✔","✘")

or with color
=SUMIFS(DailCard!$J$6:$J$17,DailCard!$F$6:$F$17,$H9,DailCard!$E$6:$E$17,I$8)

and custom format
[Red]✔;;[Green]✘

[AliGW]

In I9 copied across and down:

=IF(LOOKUP(2,1/((DailCard!$E$6:$E$17=Tracking!I$8)*(DailCard!$F$6:$F$17=Tracking!$H9)),DailCard!$J$6:$J$17)<>"","ü","û")

Set the font to Wingdings, and then use conditional formatting to turn the cell contents either green or red.

Please mind your manners: remember to say 'thank you' when people offer help. It's all for free - you are not paying us!

[davsth]

=IF(SUMIFS(DailCard!$J$6:$J$17,DailCard!$E$6:$E$17,Tracking!I$8,DailCard!$F$6:$F$17,Tracking!$H9),"✔","✘")


then conditionally format the values text colout to green and red for your outcomes. The tick and cross can be used as the values on your spreadsheet, as pasting here changes them!

[jimmiboy]

yes its working let me try with full data

thkx

[AliGW]

Whom are you addressing and which of us are being ignored?