Timeline for Nested IF, returning cell value - might contain a hyperlink
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 4, 2023 at 9:24 | answer | added | MGonet | timeline score: 0 | |
| Oct 3, 2023 at 23:05 | comment | added | Rita | Prior to adding the HYPERLINK portion into the formula, the nested if worked but it did not return the hyperlink, just the text in the cell. | |
| Oct 3, 2023 at 22:55 | history | edited | Rita | CC BY-SA 4.0 |
added 105 characters in body
|
| Oct 3, 2023 at 22:54 | history | edited | Rita | CC BY-SA 4.0 |
deleted 2 characters in body
|
| Oct 3, 2023 at 22:52 | history | edited | Rita | CC BY-SA 4.0 |
added 2 characters in body
|
| Oct 3, 2023 at 22:50 | history | edited | Rita | CC BY-SA 4.0 |
added 232 characters in body
|
| Oct 3, 2023 at 22:43 | comment | added | Rita | If CMD!E2 equals 1... I want CMD!A5 to return whatever is in NonBrand!A5 (It contains a hyperlink to a document template). Else check if CMD!E2 equals 2... I want CMD!A5 to return Agile!A5 (It contains a hyperlink to a document template) else....etc. through CMD!E2 equals 6.... If nonBrand!A5 doesn't contain a hyperlink just return the text. the hyperlink that it returns gives an error when clicked on that the site cannot be opened. It is internal to our co. The cells that do not contain hyperlinks are returning hyperlinks that obviously don't work not just the text in the cell. | |
| Oct 3, 2023 at 22:20 | comment | added | CommunityBot | Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. | |
| Oct 3, 2023 at 22:20 | comment | added | Rohit Gupta | I am confused about what your question is. How does your code not work? What does it do or not do? | |
| Oct 3, 2023 at 22:10 | history | edited | Scott Craner | CC BY-SA 4.0 |
added 18 characters in body
|
| S Oct 3, 2023 at 22:02 | review | First questions | |||
| Oct 3, 2023 at 22:20 | |||||
| S Oct 3, 2023 at 22:02 | history | asked | Rita | CC BY-SA 4.0 |