Formulas
Discussion List
- 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…
- Good afternoon! I am trying my hand at getting some detailed information about hours put in by volunteer by location. What I am trying to pull is from the screen shot in the two attachments. here am I…
- Is this still a known issue with the TODAY() function OR is there a way to get around it? https://community.smartsheet.com/discussion/59131/sheet-formulas-not-auto-updating?_gl=1*hx7amf*_ga*NDg5OTI2NT…
- I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert m…
- I need help to collect a sum of financial information based on a range of dates in the future (or past) SmartSheet Name: Renewals-Active Column Names: 'MRC' is a text/number column and contains the fi…
- =INDEX({Do Not Use Art List Range 1}, MATCH([Distributor Name]@row, {Do Not Use Art List Range 2}, 0) =INDEX({Do Not Use Art List Range 1}, MATCH([ARTNAME}@row, {Do Not Use Art List Range 2}, 0) I can…
- Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what…