-
Employee In Take Form: Trying to auto check selections based on 1 and 2 column criteria.
I have many columns created with a checkbox. Ten columns are labeled as required devices for employee types. [Employee type column named "Role"] When a certain employee type is entered in the "Role" column the "Devices" column check boxes would be auto selected showing what devices are required for that Role. Example: If…
-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
Adding updates to cells
Hello everyone I need some assistance in updating individual cells. Listed below are columns, each one pertaining to external software tools we check daily. The rows are network elements. If a tool is ready, my team would mark the cell, corresponding to that network element with a Y to indicate it's ready. N is not ready…
-
How to use any date within a date range as formula criteria?
O, great wizards of the Smartsheet community, hoping you can help me cast a formula spell. Trying to create a formula to flag if a resource is overallocated in a master sheet that tracks resources across multiple projects. NOT using either the legacy resource management or RM by SS, just core Sheet functionality. I managed…
-
What is the sheet limit for a free trial user?
I'm using the free trial and I'm getting a notification that I need to upgrade my plan to create more sheets. Does anyone know what the sheet limit is for the free trial, and where that information is shown? Thanks!
-
Add Contact details on bulk upload
I am trying to add contact details on the bulk upload but it allows me to add just name and email. I want to add Name, title, email, company name, office phone number, mobile phone number etc. how can i do that?
-
What reports are tied to a sheet?
Hi - is there a way to see which reports a particular sheet is feeding?
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
How do i create a formula to source information from another sheet with multiple countifs?
I am trying to setup an automated metrics sheet from many other sheets and I am stuck on the very first "reference another sheet" formula due to the conditions (countifs) that I'm trying to get it to pick up. Here's the example: The metric sheet is trying to count KPI's from other sheets, for this particular instance a…
