-
Formula Only Column
Hello! Can the entire column have the formula in each cell without it marking it as a new row? Status Column = Drop-down Column State Column = Symbols Column (with red/yellow/green symbols) Goal: State column automatically updates based on Status column. Example: If Status column says “sent for approval” then the my State…
-
Single or multiple project Status Widget
Hi, I would like to see a progress report as shown in the attached image of individual project sheets or across many project sheets. Functionality would include clicking the numbers to see the rows and take action on them.
-
Row Locking Now Requires Paid User
For the past 3 years I have had free license users managing a sheet and locking rows. Seems as of yesterday they lost the ability to lock rows and the annotation states that they need to upgrade to a paid user in order to do so. Can someone confirm this is the new normal? Maybe provide a link to a announcement that states…
-
Update Requests
HELP / VERY ANNOYED Today my Business Administrator was going about her business and Smartsheets without any communication to me as admin and paid user license or prior notice, seems to think it was ok to commercialise the update request function and convert a free log in / collaborator into a paying account user. They are…
-
Send Row function not working
I understand on 9/19/2019 Smartsheet changed unlicensed user functionality. The send row function is now no longer working for a two users I share a sheet with. The function is grayed out and returns a message to upgrade to a paid level. They cannot cannot perform their job duties without this function. The UNM HSC should…
-
How to right-size a Project Portfolio?
This question may be more on Project Management and Culture than it is solutioning in Smartsheet Software, but possibly some of you have done something creative in Smartsheet to help your organization. I have been with my organization for a year now and have been able to build out a project portfolio. Having the visibility…
-
Community Login is very random and troublesome
When I go from SmartSheet to the community to see great ideas, it always asks me to login to post comments or see details. So I hit Login, then it takes me to my smartsheet page that was open. Then when I go back to the community forum, it says to login. And on and on. With a few different clicks it finally seems to work,…
-
Summary rollup
Hello, I've never used Smartsheet and would appreciate your help. I'm working on a budget, we have 40 departments and each department needs to submit their budget. So I have 40 sheets and they are exactly the same, (same columns and same rows), the only difference is the data. What is the best way to add up all these 40…
-
Automation Workflow - Error Check
Hello! I am setting up an approval workflow and have run into some questions. Example: Trigger: If "Status" is set to "Sent for Approval" Action: Send approval to "Final Approver" Now, it's a very simple workflow, but, if my "Final Approver" is not populated, or there is a typo, etc. Is there a way for it to…
-
Dashboard - Gantt Show Only Today Forward
Anyone know how to make dashboard widget of a gantt chart only show today and forward? It displays correctly in the Report Builder as there is an option in Settings > Timeline Display to check the box "Open to today's date". Can't figure out why it won't do this in Dashboard widget. You can scroll to today and it prints…
