-
Lead Time calculation
Hi I am trying to create a lead time calculation to see when a request for work was submitted vs what the due date is. Purpose to report on lead time to promote better planning. I had this working when I had a request date in my form. However I subsequently changed that field to a "created date" system field to auto…
-
How to use IF statement formula
Hi Smartsheet Community, I currently need help in generating a formula where in I have multiple countries in a dropdown column and I need to identify which region they are from. Ex: A form collects data from users and they input their country. In the back end (grid), I need to collate all entries per region. So Country…
-
Formulas to set up KPI's for shipments requests
Hi, I need some help with forumals which is not my strength, thanks in advance. What I need is to set up KPI’s measure for my shipments. There are 3 parties involved that need to complete their own step. Once each step is completed by each party (regulatory, WHS and Logistics). it will record a date highlighted in the…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
Is there a formula I can use to count how many points someone has received?
We are using smartsheet for submissions for a point-based program we are running. When someone submits an item to the smartsheet through a form, they are awarded between 1-6 points based on what the item is that they submitted. Is there a formula I can use to count how many points someone has received so far, based on the…
-
IF Error Function help
Hello, Request your help to figure out what I may be doing wrong here. Please see the screen shot below The formula is on the % complete column below. I want the #DIVIDE BY ZERO to be a NULL value and was trying to use the formula below . The formula gets the desired result but I want the I want the #DIVIDE BY ZERO to be a…
-
Automatically Organizing Rows into Hierarchy
Hello Smartsheet Community, I am yet another formula-deficient SS user. Looking for insight on a formula or function I can set up, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy". I have created a…
-
Creating formula with multiple items selected
I have a sheet that has a field that allows multiple items to be in the field. I want to create a formula that will allow me to count the row if even one of the items in the row matches my criteria but it's only counting the row if there aren't multiple items in the field.
-
Adding Multiple Criteria to a COLLECT Function
I have a working formula gathering the MEDIAN of a group of numbers that fall within a date range used in a trend chart in a dashboard. I now want to add two additional criteria for cases when the dashboard user would like to calculate the MEDIAN but exclude certain values (referred to as 'HOLD' and 'Strategic' data) from…
-
Lock Column Settings
Hello all!!! Quick question I feel like I know the answer to. But is it possible to change a lock column setting so the column locks after a condition is met? For my example a column to only lock after a status is changed to a certain value.