User Profile
Rapaille
Copper Contributor
Joined Feb 23, 2023
User Widgets
Recent Discussions
Calculated column with greater than symbol in another column
Hello, I have a SharePoint list with a column specification in 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, Hans395Views0likes1CommentWeeknumber 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, Hans880Views0likes2CommentsCalculate 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, Hans531Views0likes0CommentsCreate 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.6KViews0likes0Comments
Recent Blog Articles
No content to show