Hi,
use this function in the calculated value:
If(TextBox1<"1000", "Incidental", "Minor") && If(TextBox1<"10000", "Minor", "Moderate") && If(TextBox1>"20000", "Moderate", "Major") && If(TextBox1>"100000", "Major", "Severe")
I am sure there is a way to shorten it down but ... not an expert
Better to nest the ifs:
If(TextBox1<"1000000", "Incidental", If(TextBox1<"10000000", "Minor", If(TextBox1<"20000000", "Moderate",If(TextBox1<"100000000", "Major","Severe"))))
Tested it; works fine(on-prem, SP2013)
Input no in Text Box control; Calculation in Calculated Value control
Thanks a lot ,its working fine now
Hi @shaunlub again
I need ur help again , if I have textbox , the result of this textbox will be based on another 5 textbox's ( he will take the highest value from these textbox) as following:
EXP1:
TXT1 : Incidental
TXT2: Minor
TXT3: Moderate
TXT4: Major
TXT5: SEVERE
RESRULT TXTBOX will be : SERVERE ( because its the height value).
EXP2:
TXT1 : Incidental
TXT2: Incidental
TXT3: Incidental
TXT4: Major
TXT5: Minor
RESRULT TXTBOX will be : MAJOR ( because its the height value).
EXP3:
TXT1 : Incidental
TXT2: Incidental
TXT3: Incidental
TXT4: Minor
TXT5: Incidental
RESRULT TXTBOX will be : Minor( because its the height value).
EXP4:
TXT1 : Incidental
TXT2: Moderate
TXT3: Incidental
TXT4: Minor
TXT5: Incidental
RESRULT TXTBOX will be : Minor( because its the height value).
how I can handle this in IFCondition Please?
I am having similar issue with calculation. I am collection date for months spanning several years. To make it dynamic I want to grab current year, then populate a PrevYear, CurrentYear, NextYear, FollowingYear. I only want to calculate current year on new form so it does change on edit. in a field "Year" I can add this formula fn-FormatDate(Current Date, "yyyy") and get current year. the field is set to integer in SharePoint.
When I use Calculated Value set to refresh on view and new mode, using the same formula it returns 0 regardless if the Calculated value is set to String or Integer. I only need to calculate current year correctly because this is what will be posted back to SharePoint, but visually I need the calculated values to display for the user. How can I get current year to populate in a calculated value?