Formulas

I am trying to return an Excellent, Good, Fair, Poor, Dire rating based on a score range. Below is the formula I am trying to use. =IF([Total Score]@row ≥ 10, "Dire", IF(AND([Total Score]@row ≥ 7, [Total Score]@row ≤ 9, "Poor", IF(AND([Total Score]@row ≥ 4, [Total Score]@row ≤ 6, "Fair", IF(AND([Total Score]@row ≥ 1,…

This is my second time giving Smartsheet a chance and it's going to take a lot for someone to convince me this platform is any good whatsoever. The Problem: I created a Portfolio from their template, and all fine as I was working through etc., except for the project plan template. For some reason, when I get to a certain…

I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…

Hello! I need to make a report/ sheet that when "Documentation Ordered" is checked, the row is copied to the report. When I try to do this, all of the other child rows are also copied to the report. I also need the blue title row (currently says "Documentation") to be included. When I try to do this, It's parent row and…

I have been going back and forth between Table and Grid because I prefer the AI Formula assistant in Grid View. I think it is the best overall tool I have used in the last couple of years. I was in a Grid View sheet today and there is no formula assistant. The icon is gone. If you click on the Smart Assist icon at the top…

Please allow the functionality of formula dates to be visible in Gantt view & the Timeline View.

This is my second time giving Smartsheet a chance and it's going to take a lot for someone to convince me this platform is any good whatsoever. The Problem: I created a Portfolio from their template, and all fine as I was working through etc., except for the project plan template. For some reason, when I get to a certain…

Hi everyone, I'm experiencing a strange issue with cross-sheet references and would appreciate any guidance. I have a sheet where a cell is populated using a cross-sheet reference from another sheet. The source cell in the referenced sheet is not a manual value. It contains a formula that uses two other cross-sheet…

Hello All - I am looking for a solution in SS to maintain our department's inventory/stock. Prior to adding materials to inventory, we collect and report regulatory and material information through workflows and approval requests. Once the workflow is complete and the material is approved, a final email is sent to the…

I have been using =IF(COUNTIF([Invoice Number]:[Invoice Number], [Invoice Number]@row) > 1, 1, 0) in order to check off a "duplicate" box and then added conditional formatting around that check box to visually assist staff with potential duplicate invoices being entered. It has recently stopped working for some reason and…