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
[Solved] Evaluating Columns To Put Result In One Column
-
- Posts: 12
- Joined: Tue Apr 13, 2010 3:06 am
[Solved] Evaluating Columns To Put Result In One Column
Last edited by Hagar Delest on Wed Sep 19, 2018 9:37 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
LibreOffice.org 3.3.* | openSUSE 11.4 KDE
Re: Evaluating Different Columns To Put Result In One Column
Please upload a real sample document instead of the picture. You can delete (rewrite with dummy data) the sensitive parts of the sample document.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 12
- Joined: Tue Apr 13, 2010 3:06 am
Re: Evaluating Different Columns To Put Result In One Column
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
Cliff
LibreOffice.org 3.3.* | openSUSE 11.4 KDE
Re: Evaluating Different Columns To Put Result In One Column
Perhaps this formula does what you want.
Code: Select all
=IF((NOW()-MAX(B3:E3))<1;"YES";"NO")
- Attachments
-
- SocialMedia_FJCC.ods
- (26.37 KiB) Downloaded 58 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 12
- Joined: Tue Apr 13, 2010 3:06 am
Re: Evaluating Different Columns To Put Result In One Column
BEAUTIFUL!!! I thank you so much from the bottom of my heart.FJCC wrote:Perhaps this formula does what you want.Code: Select all
=IF((NOW()-MAX(B3:E3))<1;"YES";"NO")
All the best to you and yours.
Cliff
LibreOffice.org 3.3.* | openSUSE 11.4 KDE