Formulas
Discussion List
- Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a qui…
- Sheet A has a week ending date column (always Sunday). Sheet A also has a column called Manpower where I am trying to write a formula. Looks like this, Sheet B Has an install date and an Installers Na…
- I'm working a formula for a RYG column based on two major sets of data: Status and Quarter Start Status and Quarter End Q Start and Q End are the dates of the quarter and they are on the sheet as help…
- Hey all, I've got Sheet 1 - List 1 that is an intake sheet with a range of opportunities (each identified by a unique opportunity number with a set number of digits) exported from our CRM program. Thi…
- Hello all! I have a formula that is stumping me - I am looking to compare a target due date versus the actual completion date. I have a formula that is partially working, but am running into issues wh…
- Bit of a complex one: Let's say I have a sheet named "Additions To Scanning Workflow" (with a select number of users) that includes 13 columns of data, one column ("Ready for Digitization Dept.") that…
- I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall …
- Hi There, I have a Smartsheet and Form that we use to calculate how long a person was checked into a function to account for down time. Since Smartsheet is not very good with calculating time it took …
- Hi there! Does anyone know if there is possible to extract a portion of a text in a cell? (to be specific, I only need to pull the first 5 characters from the left) I currently have a formula to "map"…
- I have 3 intake sheets for a multi tier blueprint, I am using data shuttle to bring in all of my clients, program and project to one master sheet and from that master sheet, I have 3 formula based che…