-
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.
-
Merged: Mind Map View (WBS View)
This discussion has been merged.
-
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…
-
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…
-
Dashboard - Fillable Sheet
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
-
Workflow and Automation Simulator
What problem are you trying to solve? I want to solve the waste of time it takes to test automations from several conditions and actions. Furthermore, the additional accounts that need to be created is cumbersome; just for checking if everything is working properly. The solution would be as followed: Show a macro view of…