-
Removing a field from the Summary & project sheets
I have a field coming from one of my project sheets feeding to my Summary sheet that's been replaced / is no longer needed. I'd like to remove it but wanted to know if there was anything I should keep in mind. If I just delete the field from the summary sections of all my projects & delete the column in the Summary sheet,…
-
Best Practices/Work Arounds for the lack of "elapsed" and "months" options
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors column leads me to a ton of extra rows that serve no purpose other than being a way to get "# edays" in the duration column so…
-
Jira Tickets that have been overwritten during a Jira Connector Sync Error
Hello All, Today, I started receiving abnormal Jira connector sync errors on a workflow that has been working for over a year. I may have received 7-10 or so. The workflow eventually timed out, and the sheet it wrote differed from what it was supposed to look like. This means it pulled in data from other sources in Jira…
-
Can you copy parent row info to child rows within the same column?
I am trying to figure out a formula to autofill a few columns in a child row with information from the parent but can't figure out how to do it without creating new columns. Is it possible to do this within the same column? The sheet is mostly used in card view so when team members add a subtask they will fill in the task…
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…