1

I am trying to get one box to check under one or another conditions.

1. when a certain cell has any text

2. When another certain box is checked

The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas.

2

I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like

6

I am trying to use a set of sheets for material tracking from various suppliers without actually having to have my employees use several sheets to do it.  I am wondering if there is a way/formula to look through a specific column for a supplier name, and in whichever row it finds said supplier it

1

Hi,

I have a series of standard processes that have the same dependency and predecessor data each time. 

I have the primary column  as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).

If pre-assembly is selected, for

3

Hi all,

 

i need to make some updates on my spreadsheets, that were not made on due time.

But i don't want to confuse people by triggering notifications and alerts of actions already completed.

Is there any way of deactivating all the "Alerts & Actions" at the same time, and then activating them

2

 

 I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct.  The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the

9

Hello everyone:)

I currently have a sheet populated via a web form. There are several people assigned to tasks.

My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. 

Lets say