-
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…
-
Restrict Who Can Delete Sheets
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
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…
-
Dashboard - Fillable Sheet
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?