-
Calculating Time Duration
Hello everyone - I would appreciate some assistance with calculating time. I have been through the 19 page discussion on time and have tried multiple formula combinations, but cannot seem to resolve the specific issue I am having. Basically, I need to be able to automatically calculate the hours and minutes between various…
-
Primary Columns in Grouped Reports: change label locations and move column
A report must use a sheet’s primary column and the primary column must be in the first report column. Labels for report groups are displayed in the report’s primary column, so if you don’t want to view the primary column in the report, or hide the primary column, then the groups’ labels will be hidden. If you copy the rows…
-
How to change auto number formula when value changes in a column
Hey! It's my first time posting here, and I really hope someone can help me! 😄 I have a formula which I'd like to modify. I will explain what I have and then how I'd want to change it. I have a formula that auto-numbers indented rows, and resets the count to 1 for every parent row, like this: → RowId column that is of type…
-
LEN() command in an Intake Form
Am I able to show a field on my Intake Form based on a column length. I have the following working on the sheet column =IF(LEN([Short Description]@row) > 15, "Too many characters", "") but I would like another field to show if the Short Description has a length greater than 15. I have a field called Validation Check that I…
-
Formula help -- If Number >Multiply > If not number > then skip
Hello, Our business uses a five-column template to input numbers or descriptors in any configuration. We now have a business request that multiplies any number appearing in these 5 columns. This formula exceeds my skill level. Can someone get me going in the right direction? I've attached an image of our columns and an…
-
New Feature: A redesigned access requests experience is now available for Smartsheet users
Hi Community, We’re excited to announce that Smartsheet’s improved asset access request experience is now live! This update helps collaborators and admins alike save time and reduce frustration by making it easier to request and allocate access to assets For Collaborators: Submit access requests with context—saving time…
-
Creating a new community
I noticed there are no communities for Professional Services firms or Engineering groups. Engineers and Land Planners will use Smartsheet differently from the Construction group. Would it be possible to create a group for this industry? It would be incredibly helpful to collaborate with those in the same field. Thank you!
-
Change summary email
There's an email that contacts on a sheet receive towards the end of the day when changes are made to a sheet. They'll receive the automated emails set up on the sheet as well as this summary of changes email. Is there a way to modify this email?
-
Resource Manager - On schedule view allow a rolled up view of effort per project
On using the schedule view, allow a rolled-up view of effort per project, rather than limiting this to a view by task. With users who are working on multiple projects at one time, the current view becomes a mess and is difficult to follow
-
How can I change the Schedule to view at a project level not task level?
In Resource Manager, I'm looking for a Schedule view or a Report that will show me people, the projects they are working on and the allocation on that project, but I would like the view to exclude the task level. The basic Schedule view of People and Assignment Details would work well if I could find a way to remove the…
