[Solved] Evaluating Columns To Put Result In One Column

[Star_Gazer]

I want to be able to put the result of columns B#-E# (where # is Column Number) as a "Yes" or blank in column F#;

The Catch is Row One are LINKS to Facebook Posts, and Facebook doesn't like users posting the same thing too quickly, so I have a pile of different posts, with the Group Names in Column A. If I can get Calc to inform me I have shared a post in the particular Facebook Groups, that would restrain me from posting 2 or more into the same group to quickly. In the attached photo example, "=IF(B3:E3>=TODAY();"YES";"")" is not working for me. I tried the Array thingy, "{=IF(B3:E3>=TODAY();"YES";"")}", but that spreads out the results from Columns F# - I#.

I have tried all I KNOW of how to try.



Thanks,
Cliff

[Zizi64]

Please upload a real sample document instead of the picture. You can delete (rewrite with dummy data) the sensitive parts of the sample document.

[Star_Gazer]

Here is a COPY of the whole document (there's no "sensitive" in the doc); These are just Spreadsheets that let me know WHEN I shared (or post) certain things to Facebook Groups, and help aid me from posting the same ones to the same Groups. HOWEVER, because I have different SHEETS, i.e. another Calc doc with over a dozen sheets, I want a way to be informed (if feasible and possible) to INFORM that a post has been shared to that group (TODAY()) or, if possible, within the past 24 hours.

Cliff

SocialMediaPostedAt1809.ods

(24.13 KiB) Downloaded 64 times

[FJCC]

Perhaps this formula does what you want.

Code: Select all

=IF((NOW()-MAX(B3:E3))<1;"YES";"NO")

[Star_Gazer]

Perhaps this formula does what you want.

Code: Select all

=IF((NOW()-MAX(B3:E3))<1;"YES";"NO")

BEAUTIFUL!!! I thank you so much from the bottom of my heart.

All the best to you and yours.

Cliff