-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
Show Off your Smartpets
Many of you have shared beautiful photos of your pets in the Community, and it is always a joy to see them! That’s why we decided to create this space for you. Introduce your animal friends, show off their new outfit, share your favorite stories, or anything else you like. Everyone is welcomed - from cats, dogs and birds,…
-
Increase sheet row and column limits
Hi Guys, What is the possibility to increase the row (20 000) and column capacity? I'm working for a company that headcount surpasses the 20 000 mark which makes it extremely difficult to utilize smartsheets, which we really want to do. This would truly make a huge difference in building a database etc.
-
Workspace Shared to panel
Hello, Would it be possible to reduce or even hide the panel showing who is shared to a Workspace? I'd like to see the names of the content within the workspace far more than who the Workspace is shared to. If the Workspace Shared to section could be minimized, that would be ideal. Thank you for your consideration, Lisa
-
New Window pop-up option
A recommendation I would like to make is adding a feature under widget behavior. When connecting a Smartsheet under widget behavior, it would be nice to have a check box or a toggle switch that asks if you would like a new window to pop-up whenever the widget is clicked. A new window pop-up is allowed if you copy and paste…
-
Need help to auto populate a formula to display a number
It is simply EYYWK## -YY= year (e.g., 24 for 2024) -WK=week (e.g. 15 for right now. The 15th week of the year) -##=sequential e.g., 3x E-runs have been created this week, so the last "Full# in the book is E241503
-
Automate Parent Status Rollup based on Descendants' statuses
Hi folks — has anyone figured out how to enable users to update statuses manually for child rows, and then have the parent rows’ status update automatically? There are multiple levels of hierarchy. For example, I have three statuses that a child row can be; In Progress, Not Started, Completed. I have figured out the…
-
Allow to send attachments without linking to the sheet and adding other Smartsheet details
For business use, the automated workflows to send automated email messages is wonderful. However, the emails that can be generated if you want to include an attachment from the sheet is unprofessional, messy, and confusing. I love the look of the emails when you send just the message. I wish I could send a message and…
-
Help with Formula
I'm working on a formula that will look at cell A if it is = "Milestone" perform this function, if not do this. Have that working. My issue is if the denominator is 0 is produces an error. I would like to add code to return 0 if denominator is 0. The top code is what I need to figure out. The bottom code is what is…
-
Countif reference range
I would like to know when in January an issue was logged. Both my month and Issues are referencing another sheet. I want a count of January issue looking at columns Issue 1 through column Issue 4 (four column range). This works - =COUNTIFS({Month}, "January", {Issue #1}, "002_Bypass Audit") Does not work -…