-
Ability to group/categorize users on the User Management page?
On the User Management page within the Smartsheet Admin Center, Is Smartsheet exploring the functionality to group/categorize users by codes or some other admin-defined designation (ex. department, team, cost center, vendor, etc.)? Doing so would make user management a bit easier.
-
Form text entry field displays last entries
In a Form, the fields that are text free-form entry fields will display the last several entries in a box. How do you clear those entries and prevent the form from displaying the most recent entries? When you click in the field, we do not want anything to display - just type.
-
Contracts, Purchase Orders, or Change Order Management
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
sum issues
HI Experts, I have issues to sum my columns. The yellow column should be the sum of the column before. I tried this formula on the sheet =column1+column2+column3.... but I get this weird result. I also tried =Sum(column1+column2+column3..) but than the result is shows always 0.0 which is also wrong. All columns has…
-
What is wrong with my IF...AND stmt?
=IF(AND([# of Days Open]@row >= 22, Status@row = "Pending Review"), "Red", IF(AND([# of Days Open]@row <= 14, Status@row = "Pending Review"), "Green", IF(AND(Status@row = "Pending Review", AND([# of Days Open]@row >= 15, [# of Days Open]@row <= 21), "Yellow")))) In my calc above, it was working fine until I added the 3rd…
-
Having an alert trigger at the same time an item is moved to an archive
I have multiple workflows that now need archive automations so they can continue to operate. For one ticketing process, the requestor needs an alert saying that their request is complete, and the request needs to be moved to the archive. The requestor is no longer receiving those alerts. Is this because it is 'moved'…
-
How to add a timestamp to sheet.
Hi All, So I am trying to build a production tracker for my company. Part of what the owner wants is for the personnel on the manufacturing floor to be able to scan their ID cards with a scanner and go into work with a piece, and then repeat the same process when the are finish and get out of work with the piece they were…
-
Forms: Ranking choices in a question
I'm working on a survey in a form. I have a question with five choices. I want the user to be able to put them in order of importance. For example, the choices are transparency, adaptability, positive attitude, dependability, and efficiency. I want the user to put these in order of what they deem to be most important vs.…
-
Report Group By Feature not Working
Hi - I am the owner of a report and backend sheet. I have shared the entire workspace with someone and they cannot change the grouping in the report. It's grayed out. They have a license (Enterprise Premier) and their permission level is set to Edit-able to share. Also, if someone else adds a filter to the same report,…
-
Syncing task owner holidays with the project timeline
Hello, I have people assigned to a project and some of them have time off during the project timeline. Is there any way to set up their holiday dates & then make them automatically unavailable during those days - even if they are assigned to a task so that I can adjust the plan? Thanks!
