114 reputation
212
bio website
location
age
visits member for 2 years, 11 months
seen Jul 7 at 12:44

Jul
2
awarded  Curious
Mar
6
awarded  Notable Question
Feb
13
awarded  Popular Question
Oct
20
awarded  Citizen Patrol
Jun
5
awarded  Notable Question
Mar
4
awarded  Popular Question
Nov
19
awarded  Popular Question
Nov
6
comment Lists not indexed, “Error in the Site Data Web Service”
Please feel free to close, thanks!
Sep
15
accepted Lists not indexed, “Error in the Site Data Web Service”
Sep
15
answered Lists not indexed, “Error in the Site Data Web Service”
Sep
12
comment Calculated column- evaluating multiple conditions
Well spevilgenius lives up to his name, though possibly minus the "evil". Many thanks! This answer got me almost all the way there and I finished it by deconstructing the formula, first testing the AND and LEN arguments and working outward from there. The final result should you want to know is: =IF(OR([Boolean A]=FALSE,AND([Boolean A]=TRUE,LEN([Text B])>0,LEN([Text C])>0)),"READY","NOT READY")
Sep
12
accepted Calculated column- evaluating multiple conditions
Sep
12
comment Calculated column- evaluating multiple conditions
By the way, a Thank You should have been in there somewhere, so... Thank You!
Sep
12
comment Calculated column- evaluating multiple conditions
Testing now, looks close but throwing syntax errors. Usually just a misplaced parenthesis but so far I don't see it. The formula with my real column names included and the boolean conditions changed to = FALSE and = TRUE (that's the only foolproof boolean expression I've found) appears below. =IF(OR([Req_VM]=FALSE, AND([Req_VM]=TRUE, AND(LEN[Storage_Sign] > 0, LEN[VMWare_Sign] > 0)), "READY", "NOT READY"))
Sep
12
comment Calculated column- evaluating multiple conditions
These are coming from an InfoPath form and the logic is this: if the boolean (Special Approval Required) is NO then I want to set a Ready for Approval column to READY, but if the boolean is YES then I have to wait for two signatures on the InfoPath form. Make sense? It's perfectly likely that there's other logic that will get this done, just haven't found a more obvious solution yet.
Sep
12
revised Calculated column- evaluating multiple conditions
added 16 characters in body
Sep
12
revised Calculated column- evaluating multiple conditions
added 16 characters in body
Sep
12
asked Calculated column- evaluating multiple conditions
Jul
26
comment Lists not indexed, “Error in the Site Data Web Service”
Yes to the index reset, not yet on recreating the service. Interestingly, if I copy one of the offending lists (custom list with only 4 columns, nothing special) to another site the copy doesn't index either.
Jul
24
asked Lists not indexed, “Error in the Site Data Web Service”