Hello - I have 3 cells in my sheet, "Assigned To" "Date Completed" "Status" I need a formula that says if "Assigned To" is any text, then then "Status" would = "Assigned", and once someone puts a date…
Hi Smartsheet, can you please consider adding a click box that reads "Convert to Sheet Summary" in your filters so that we don't have to recreate a formula as a filter to generate a report. In additio…
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 whe…
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 da…
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 st…
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 autofi…
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 i…
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…
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…
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 bu…