Sharepoint calculated if statement not working
I've done a lot of googling and no solution I've found works for me.
Under the screenshot I have translated what it says.
=IF(ISBLANK([ToDate]),"",[ToDate]-[DaysToWarn]
This only throws an syntax error. I've tried many different solutions but none of which seems to work.
I even built a replica in my test environment to see if that worked, which it did. I'm out of options and I don't know what I am doing wrong.
The problem, most likely, is due to the parameter separator. The documentation says:
All example formulas in this topic use commas
","as the parameter delimiter character. In some countries, the comma is reserved for use as the decimal mark. In such countries, users creating a calculated field must use semi-colons";"as the delimiter character.
If I'm correct to assume your localization is Swedish, the decimal separator is ',' (comma), and hence the parameter separator to be used shall be ';' (semicolon).
=IF(ISBLANK([ToDate]); ""; [ToDate]-[DaysToWarn])
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?