-
Progress Bar and/or Completion % by Check Box Column Status
Hello! I'm looking to use a formula that will calculate the percentage of tasks completed by row based on whether or not the check box is "checked." I have five check box columns, so if one is checked, the % Completed column shows 20%, if four are checked, 80%, etc. I know I need to use IF/And statements, but I keep…
-
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…
-
Formula to only include status of parent rows and the contact assigned to them
Hi folks, I'm trying to create a COUNTIFS formula that calculates the number of "In Progress", "Issue/At Risk", "Postponed", and "Complete" statuses that a specific contact has (in this case, the user assigned in the "Lifecycle Lead Column"). The problem I'm having is that I only want to count the parent rows, not the…
-
Automations after a status change
Hi, One of the things I'm using Smartsheets for is a "stocklist" of vehicles within our business. On this stocklist, we have the opportunity for sales execs to put vehicles on hold and depending on certain criteria, this can be for 24 hours, 48 hours, or 72 hours. This is actioned on request by managers, and we have a…
-
Need a formula to recognize a checkbox and match it to a name
I work in a property mgt department and we've built a room inspection form. Our suites have rooms assignments based on the bedroom within the suite. The columns for the form are broken into sections of columns but I have the rooms assignment rosters broken down into rows. I need a formula that will recognize the box is…
-
Gantt from JOIN COLLECT Dates
Good day Is it possible to get Gantt functionality to dates we got from JOIN COLLECT formula? Thank you in advance!
-
Get first & last date of a month from a date in another column
Im trying to get 2 formula's that will calculate the first & last dates of a month based on a date in another column on the same row. So for instance if 'Date of Movement' column has 10/1/2023 i would like the 'Start Date of Month' column to return 1/1/2023. Likewise if 'Date of Movement' column has 10/1/2023 i would like…
-
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,…
-
VLOOKUP with multiple criteria help
Hi, I have a sheet which has 1 column showing a document name, and another column for document revision number. I need to make a vlookup which returns the owner of the doc, based on the document name and revision number. I'm aware that the simplest option is to concatenate the two columns but I'd prefer not to add another…
-
Collecting and adding all Numbers in a cell
Dear all, I need to collect and add all numbers in a cell - the problem is there are also letters and signs in that cell and I do not know how many numbers, letters and signs the cell has (all I know is the numbers are between 1 and 9), e.g.: "Mo1/1" -> result shall be 2 "1A-3(team) & 4" -> result shall be 8 "1 (max) + 5…
