-
Formula on deleting the entire rows if the checkbox is ticked
Hi Team Is there a way that the rows can disappear after we’ve ticked them delivered please?
-
IF/OR Formula help
Trying to Auto-fill a value in one column based upon "fixed" drop down list of values from another column. So this is the formula I am starting with. =IF([Product Family]1 = "7765", "252 Industrial", "265 Commercial") I have (3) additional values I want to include that will satisfy the true portion of the formula. How do…
-
Not receiving notifications
Hello all... I am fairly new to Smartsheet and this Community but have come across my 1st issue. I have created a Smartsheet where multiple users will be entering data for items to be purchased through our Purchasing Dept. I have created a formula where, when the "Ordered By:" and "Ordered Date" are populated, the "Status…
-
Not receiving notifications
Hello everyone, I am fairly new to the Smartsheet app, as well as community. I am having issues with not receiving notifications, when a certain task (column) is populated. I have created a Smartsheet to order materials from outside vendors. There are to be multiple employees adding stuff to this sheet, and one or two…
-
Unsubscribe from email alerts
Does anyone know what actually happens if a user selects the unsubscribe option when they receive an email alert? Many of our alerts are not necessarily optional I don't want users to be able to just opt out of them at will. I selected this on one myself to see what happens, but I can't find anywhere on my sheets or the…
-
today plus x networkingdays
how do i build a formula that gives me the actual date for today + 35 working days?
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Resource Allocation in Manufacturing
Hello, I am curious if anyone has tried to use Resource Allocation for capacity planning in manufacturing. Our projects are long term releases against blanket orders and I would like to use the Project Sheet to view where Production/Manufacturing resources are over-allocated and prove the need for additional staffing or…
-
Gant Chart Time Dependencies - Hours
Please let me know if anyone has figured out how to get the gant chart down to hours. The minimum that I have seen is at days and then it goes to weeks, months, and years. We have a project that will have dependencies on certain days that go down to the hour.