Sign in to join the conversation:
Hello,
I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days.
Is there anyway of setting the sheet so saturday & sunday do not count as days?
You may need to use a WORKDAY or NETWORKDAYS formula somewhere. You could put it in a hidden column or use it to drive a RYG column and base your conditional formatting off of that.
Thanks very much. I will look at this on Monday, have a great weekend.
Thanks again
Hi All I have created a support request form and sheet to allow functions to request support from my team. When a request comes in, it is assigned a unique support ID number. I then assign the request to a member of the team vias drop down. I have added an automation to message the requester when a team member has been…
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
Up until yesterday (11/3/25) I was able to click on the top of a column and sort my column. This worked for me yesterday morning but when I went in to work in the afternoon I was not able to sort columns anymore. Also it seems my filters are not working. I am not the admin for this sheet but the admin is saying nothing has…
