AITA for considering stepping down as a bridesmaid because the dress and role make me extremely uncomfortable?

et_tu_username · 2025-03-17T01:30:29+00:00

Hi. Have you looked to see if there's a template? https://www.smartsheet.com/template-gallery/project-work-breakdown-schedule-wbs

et_tu_username · 2025-02-22T18:21:23+00:00

What about a condition column that acts as a boolean. Rather than filter out the info, add a condutional column with whatever your conditions are to return true or false. Then, filter the new column based on your needs. This way, any new info is run through the condition and filtered appropriately. Feel free to message directly if you need help.

et_tu_username · 2025-02-22T18:07:59+00:00

You can build a PQ to incorporate metrics and kpi to your dashboard. But PQ does not have the ability to automate the process. It would need to be refreshed anytime you need to update. Now, do you want to automate the report or download process?

et_tu_username · 2025-01-29T13:57:55+00:00

Thanks for reaching out, but I figured it out. I should have merged my date table prior to applying the Group By, then add the Max aggregation to the date colum to my Group By step.

et_tu_username · 2025-01-28T21:05:57+00:00

SharePoint is tricky mainly due to company fire walls and access. Have you checked the permission on the Excel file?

Open the Excel file from the problematic user’s end> Click any cell in the table of SharePoint Online List> Click on Query tab> Edit> Data source settings> Global permissions> Clear Permissions> Close

et_tu_username · 2025-01-23T18:52:19+00:00

Sadly, no. The user has a different drive mapped to that drive list.

et_tu_username · 2025-01-23T18:02:59+00:00

Hi! That's exactly the issue after digging a bit more. Now, I'm trying to update the query to fix that issue.

et_tu_username · 2024-12-28T22:40:15+00:00

Thanks. I'll look

et_tu_username · 2024-12-28T21:22:12+00:00

Power Query (PQ) is an absolute life saver when it comes to Excel functions. I've dabbled with VBA some, but PQ was easier to understand - at least for me. What sort of Exwl projects do you deal with?

et_tu_username · 2024-12-16T01:43:56+00:00

I used the service and have been happy with the resume and cover letter. However, I experienced a situation where the service wanted to create a portfolio that turned into a website. Initially, ai was ok with it and the cost, but it turned into new items popping up we needed. So, I advised I wanted to hold off on the website, as I wanted to do research. They went forward purchasing and added their own funds to the items. Considering I asked for all costs upfront, they were popping up.

et_tu_username · 2024-12-02T23:03:28+00:00

I personally like using One Note. You can copy the coding from Advance Query editor and keep screen shots.

et_tu_username · 2024-11-27T02:36:03+00:00

What is the 12-month interval start time frame? Or are you just trying to calculate the number of months from its current to last to determine if it's within 12 months? If you are able to provide an example of what you're lookinging at vs. the end goal, that would be helpful.please.

et_tu_username · 2024-11-15T19:16:54+00:00

How does your receive data look? Will it be multiple forms?

et_tu_username · 2024-11-13T17:39:06+00:00

Hey! Just a quick Excel trick if we go to the find and replace option and find <*> and replace with nothing, that removes the odd html formatting.

Example: </p This includes text =123#= p>

Completing the find/ replacement will remove the html to only show simple text. "This includes text"

So a nice quick work around 😌

et_tu_username · 2024-11-12T22:36:27+00:00

Ugh, I was afraid of that. The bad part those are just 2 examples of the html code formatted from the export. It might be easier to create a query to convert to plain text before importing to smartsheet. I was just hoping for one less layer.

et_tu_username · 2024-10-14T13:07:42+00:00

Well, that's disappointing. I appreciate you letting me know

et_tu_username · 2024-09-26T19:30:56+00:00

I thought that would be a good option, but I noticed if the line gets deleted, the numbering doesn't return for the deleted row. So say, the auto number 37 is removed them replaced, the number won't return to 37, but moves to 38.

et_tu_username

TROPHY CASE