User Profile
Rapaille
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Calculated column with greater than symbol in another column
Hello, I have a SharePoint list with a column specificationin which values like '> 8' or '< 15'. In another column named Tested value people put the tested value like '11'. Now I want a third column with the result 'passed/failed' in it. Can I make a calculation with the specification column with symbols? Thank you in advance for your help. Kind regards, Hans312Views0likes1CommentWeeknumber when week starts on Sunday
Hello, I'm using below formula to get the week number in a SharePoint list column. In this formula the week starts on Monday. How can I get the week started on Sunday? =CONCATENATE(TEXT(IF(INT((Productiedatum-DATE(YEAR(Productiedatum);1;1)+(TEXT(WEEKDAY(DATE(YEAR(Productiedatum);1;1)-1);"d")))/7)=0;52;INT((Productiedatum-DATE(YEAR(Productiedatum);1;1)+(TEXT(WEEKDAY(DATE(YEAR(Productiedatum);1;1)-1);"d")))/7));"0")) Kind regards, Hans727Views0likes2CommentsCalculate week number when week starts on Sunday
Hello, I'm using below to calculate the week number from a date in a SharePoint list. Now I want to start the week on Sunday instead of Monday. What do I need to change for this? Can anyone help me? =CONCATENATE(TEXT(IF(INT((Productiedatum-DATE(YEAR(Productiedatum);1;1)+(TEXT(WEEKDAY(DATE(YEAR(Productiedatum);1;1)-1);"d")))/7)=0;52;INT((Productiedatum-DATE(YEAR(Productiedatum);1;1)+(TEXT(WEEKDAY(DATE(YEAR(Productiedatum);1;1)-1);"d")))/7));"0")) Kind regards, Hans469Views0likes0CommentsCreate pdf from Excel and upload to SharePoint site by using vba
Hello, I have an Excel worksheet with a form for calibration. The idea is that people after they completed the form start vba by clicking a button. The code will create a pdf and save it in a folder on a SharePoint site. The code I created works when I save the file on a local drive, but when I want to save it on a SharePoint site I get an error. When I paste the link to the folder in the browser, it will bring me to the correct folder. When using the file explorer I get the message 'Windows can't find 'https:........'. Check the spelling and try again. Who can help? Thank you in advance for your kind cooperation. Hans1.5KViews0likes0Comments
Groups
Recent Blog Articles
No content to show