-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Counting only weekdays Formula?
Hello, I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Update Request Complete
Hi, Is there a way a completed update request can be re-instated? I have a situation where an automated update request was sent with 13 rows. The person completed a couple of rows and submitted them. He then went back to the same link to complete the other rows. The form allowed him to fill in the details; however, when he…
-
How to make Value be based on a cell for Automations?
Hello, I have a automation where i need it to trigger when a cell matches another cell value. So I have a column with an requestor email that is inputted by a form that Person A would fill out. I also have a modified by column to show who was the last person/automation to modify it. I also have a text field for additional…
-
Allow Unlicensed Users to Hide Columns
Is it possible to allow unlicensed users with certain permissions the ability to Hide a column.
-
Mind Map View (WBS View)
Add Mind Map View which would be a graphical representation of the work to be done or simply WBS. Obviously, Mind Map View should be created based on your list of tasks in Grid View. Having such a clear, hierarchical, and structured view of the entire project scope would be incredibly useful. The ability to choose how the…
-
Dropdown options limited to certain people
Hello, Quick question. So i have a drop down menu with 6 options. Is it possible to have on the form where if someone is selecting a option they, depending on who they are, can only see options 1-3? So it would only be a select group of people and the option choice may very. So person 1 can see 1-3 while person 2 can see…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Automation
Hallo Team smartsheet Struggling with following below you see a list Colom Picklist is a Tik box ... To prepare a list for the warehouse we need to tik the box manual. once the warehouse scanned , the sheet is proccessing a new line and when in colum action is OUT the tink box in Colom needs to be tikked automatic. But it…