-
REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child…
-
Counting overlapping days between two time periods.
Hello, Our companies fiscal year does not match the calendar year, our fiscal year starts April 1st and ends March 31st. I'm looking for a clean way to count overlapping days. Task Start = 4-15-18 / Task End = 6-20-20. Fiscal Year 1 = 4-1-18 to 3-31-2019 Fiscal Year 2 = 4-1-19 to 3-31-20 How many Task days are in Fiscal…
-
Update Requests
I created an update request for our staff to use when we receive subsidy payments. I have the update requests setup so only certain staff will receive the request. It was brought to my attention this morning that some staff are receiving the request who were not on my list for delivery. How is this happening and how can I…
-
formulas in update requests
Hi, i'd like to use smartsheet for end of year bonuses. I ideally would like to send an update request to managers with the info below. I can lock all cells so that the only one they can update would be column C - but is there a way on either update request or something where if they change the drop down of column C a new…
-
Chart Legend Renaming
Can you edit the legend titles? I created a chart widget but the legend has the title for the column that the metrics are in (I currently have the metrics on locked rows inserted above the info on the sheet)
-
Stakeholder Registry Autopopulation
Hello! I am looking for a way to auto-populate my Assigned To column from my Stakeholder Registry. Any way of doing this? Or is the solution manually updating your Smartsheet Contacts?
-
Project Column Creaion.
Hi all, I have approx. 200 projects on Microsoft Project Server and now I want to migrates all these projects to smart sheet but unfortunately, a lot of project columns are not migrated to smart sheet and now my question is that how will I create a single column for bulk of projects.e.g Project ID column to show for all…
-
Charts - Legend adjustments
Hello smartsheet, Is there a way to change the icon size and text size of the legend in the charts? For several of the charts I create require legends, but the legend size is out of scale with the rest of the chart. Thoughts? Cheers, BB
-
Unannounced changes, new behavior, or am I being gaslighted?
Several times over the past few weeks/months, I have noticed odd behavior when using Smartsheeet. I won't go into them here, rather I have a specific instance. Normal Behavior: I have 3-5 browser tabs open to different Smartsheet objects that I am working with/on. When I am done for the day, I do not put my computer to…
-
Enhancement Requests: Improved Row Reminders
Every once in a while, I run into a situation where I would like to send a Row Reminder, but Smartsheet's implementation does not help me. 99% of the Reminders on a sheet are generic and can automated, I'm not talking about those. I just talked to someone and they said "if you don't hear from me in 21 working days, contact…
