-
Renaming columns affects reports
Why is it that changing the name of a column in a sheet breaks all the reports that include that column? I need to go into each and remove the column with the now defunct name and then add the column back into the report again. This is tedious and frustrating (what if I miss a report?). Fortunately conditional formatting…
-
Why doesn't my mouse wheel work within a sheet?
Scrolling through a big sheet with the wheel on my mouse would be great. The scroll wheel works in every other thing I do - including parts of Smartsheet- just doesn't work within a sheet. I've changed settings on my mouse but still does not allow me to scroll within a sheet- forces me to grab the slider on the side or…
-
Reporting Using Parent Child Relationships
Hello - I have created a report to display the current user's list of high level milestones. This list is supposed to display any milestone that is blank under parent child relationship. This ensures only high level tasks are displayed. Its seems to work fairly well, but I have encountered one issue. For one of my sheets…
-
Archiving Meeting Minutes
We have to archive (over several years) and be able to search our meeting minutes for accreditation purposes. I can use the Meeting agenda sheet (Meeting Management set) for both agenda and minutes. How can I save the July agenda/minutes and create a new agenda/minutes sheet for the August meeting? Should I create a…
-
Populate a Sheet from SQL server query (C#)
Hi Everyone, I need some help with a fairly simple task we are trying to accomplish -but i am having some hard time getting it to work - We are reading from a SQL server and some of the result needs to be populated into Smartsheet. As i am using Dataset - and trying to update each value on the variable "ProjectName" into a…
-
Working Days
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?
-
Dashboard showing status of symbols
Hello community, I apologize if this comes across as trivial, but I am wondering what the optimal solution is to show charts (pie, mostly) showing what percentage of cells in a sheet have the symbol Red Dot / Green Dot / etc. Can I access those symbols directly? Or can I do some sort of IF statement which assigns a value…
-
Sharing one sheet to two workspaces?
Is there a way to share one sheet to two workspaces? Would you have to copy the sheet and have all fields linked so that the changes you make to one sheet would show up in the other sheet? Thanks!
-
Delete all comments and data of a sheet
Hi, how can I delete all comments for all rows in one go for a sheet? Thanks
-
Scrambles Subtasks
Is there a reason why my subtasks keep getting mixed up in different entries? For Example, Job "A" has 10 subtasks, Job "B" has 5 subtasks. Once saved, Job "A" showing all 15 subtasks???