Timeline for Calculation based on IF & ELSE statement for current year or next year
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 3, 2017 at 14:46 | vote | accept | CommunityBot | ||
| Nov 3, 2017 at 14:41 | comment | added | itsmebasti | @HUBBY0716 had to fix a couple things, now it should work. | |
| Nov 3, 2017 at 14:40 | history | edited | itsmebasti | CC BY-SA 3.0 |
added 6 characters in body
|
| Nov 3, 2017 at 14:34 | history | edited | itsmebasti | CC BY-SA 3.0 |
added 28 characters in body
|
| Nov 3, 2017 at 14:29 | comment | added | itsmebasti | @HUBBY0716 If you need more conditions, just add them to the surrounding IF statement. Ya sorry I didn't check if the syntax is valid, let me doublecheck that. | |
| Nov 3, 2017 at 14:27 | comment | added | user48169 | I like your logic here, but I'm getting an error (Error: Syntax error. Extra ','). Also, how can tell the difference between months? For example. What if I only want the calculation to take place if the closedate month is either Jan Feb or Mar to be populated in the field? | |
| Nov 3, 2017 at 13:47 | comment | added | Raul | +1 Good use of concatenation as a string and converting it to a value! | |
| Nov 3, 2017 at 13:36 | history | edited | itsmebasti | CC BY-SA 3.0 |
added 82 characters in body
|
| Nov 3, 2017 at 13:30 | history | edited | itsmebasti | CC BY-SA 3.0 |
added 82 characters in body
|
| Nov 3, 2017 at 13:25 | history | answered | itsmebasti | CC BY-SA 3.0 |